Dim rst query. 1

[RBP]

Can anyone help with this quickie?

I have an Access DB, with various Forms based on Query's.
What I would like to do is -
On the form add a nav button to select next/prev record, (plus some other stuff).

I have tried :
Dim db As Database
Dim rst As Recordset

Set rst = Me.Recordset : when executing this line I get error code 13 type mismatch.

onclick button rst.move next etc.

I have tried to define the DB as DAO. and ADOB. (bit vague on these...)

No joy, I have also tried RTFM Microsoft help, and as usual all of it is vague.

I KNOW it is something simple, as I have coded similar in Access 97, this is 2000.

Can anyone point me to the correct part of the manual?
Thanks in advance.
etc.

 

[hymn]

try
Dim db As DAO.Database
Dim rst As DAO.Recordset

Make sure that in your references thatMicrosoft 3.? is ticked

Hope this helps
Hymn

 

[RBP]

Used the code below, checked DAO3.
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim fld As Field
Set rst = Me.Recordset
Still get run time 13, type mismatch, on line above.
Will keep trying thanks.

 

[PHV]

You may try this:
Set rst = Me.RecordsetClone

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RBP]

All sorted now thanks.