Hi -
If you are using this in a form, try using DoCmd.GoToRecord ,,acLast.
This will go to the last record in whatever dataset the form is using as its
RecordSource,
e.g. tblEmployee
If you are using the form to add new data, use acNew instead of acLast.
John
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
--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201003/1