Prev: Import file with spaces in file name
Next: Gathering information
From: John Spencer on 18 Mar 2010 19:42
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
First  |  Prev  | 
Pages: 1 2
Prev: Import file with spaces in file name
Next: Gathering information