On Open Goto First record

[Bernd Smits]

Hi,
I would like that when I open my form it goes automaticly to a specific
record in the table. What's the code for do this? And have I to insert in
the On Open event?
Thanks
Bernd

 

[Allen Browne]

See:
Return to the same record next time form is opened
at:
http://members.iinet.net.au/~allenbrowne/ser-18.html

The article explains how to store the value in a table, and automatically go
to that record next time you open the form. You should be able to adapt that
approach to suit your needs.