Pulling in an autonumber before displaying form getting errors

T

terry beckman

I am trying to fix an error I get when trying to pullin a autonumber to a
form before displaying the form. Access 2002 is attached to a SQL Server
database.
At time of error is in a:
DoCmd.GotoRecord, , acPrevious
DoCmd.GotoRecord, , acNext
Error is occuring on acPrevious record. I have tried to insert the data
with an SQL statement and then doing an:
DoCmd.GotoRecord, ,acLast.
All of these draw errors in the Access Project I am working on, but other
computers do not have this issue. Any suggestions will be welcome.

Thanks!
Terry
 
Top