Finding Last Record
If you want to move to the last record that the form is bound to.
DoCmd.GoToRecord acDataForm, "NameOfForm", acLast
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
Wes wrote:
Being very new to Access I am struggling a bit, so need some assistance.
I have an ACCESS 2000 manual and keep trying to figure it out, but I am
just a bit ACCESS deprived.
I have a form that will be used for New Employees. When I OPEN the
form, (OPEN event, I think,) I need to get to the last record in my
table. I have tried
DoCmd.GoToRecord acDataTable, "SalesAssociate", acLast
but get an error saying the table is not open.
I have tried several other things, but nothing seems to work.
I know I have it wrong, but can't figure it out.
Any suggestions
Thanks
Wes
|