Quote:> A beginner-level question:
> Is there a clever way to move around in a dynaset; i.e. better than
> just using arrow buttons with "moveNext" command. Something like
> scroll bars, which can move you - lets say 20 records forward? My
> intelligence is not enough to develop something in that line.
> - upi -
Hi Urpo !
Well, nothing easier than that.
put a ListBox and several Textboxes (i.e.) to your form.
TIP: do not use the data-control which you can set from the ToolBox.
then try s.th. like this:
---------------------------------------------------------------------------
First declare this variables in the global modul:
global daba as database
global rs as recordset
global st as string
---------------------------------------------------------------------------
then set the code like this:
Private Sub Form_Load()
set daba=opendatabase("Your DataBase")
set rs=daba.openrecordset("Your_Recorset")
while not rs.eof
form1.list1.addnew rs.fields("Your_Field")
rs.movenext
wend
rs.movefirst
end sub
Private Sub List1_Click()
' ' works fine if the field is not duplicated (use index) for that
st = "select * from your_Recordset where your_fields=" & " ' " &_
Form1.List1.text & " ' "
Set rs = daba.OpenRecordset(st)
Form1.Text1.text = rs.Fields("your_Field")
... go on like this ...
End Sub
this is the way I use in my progs.
regards,
Paul
--
**********************************************************
happy hearts fall by my stupid hearts