domcd.findrecord doesn't move the cursor?

[mikeger]

Hello, i'm new to access and i need some help! I'm using a recordset and i'm using docmd to find a record. It works, and the the data on the form is selected. But when i run "msgbox(.fields("LastName")) it show the FIRST record, not the current record that is selected on the form when i execute "docmd.findrecord 'Mike',acEntire, True, acDown, True, acCurrent, True". Why? How can i navigate the recordset without .movenext, .movefirst,etc.?

Thanks in advance!

 

[Jeanette Cunningham]

If you have a form open, you can use the form's methods instead of using a recordset.
Then you can use FindFirst with the form's recordset clone and set the form's bookmark to the same record that is selected by FindFirst.
You use the form to navigate the records showing in the form and leave recordsets for things that can't be done via the form.