Open form to last record

[darian]

I am working in Access and want to be able to open the form to the last record instead of the first. Even better would be to open it one past the last record to allow for update without seeing the existing data of the last record. Thanks for any help.

------------------
Thanks in advance,
Stanley
[email protected]
ICQ: 676835
*~*~*~*~*~*~*~*~*~*~*~*~*
All typos are the cause
of sleep deprivation and
constant headbanging on
the keyboard.
*~*~*~*~*~*~*~*~*~*~*~*~*

[Clunietp]

On your Access form's load event (or similar) use the movelast function, then an addnew function to get to the last record, then add a new one.

(sorry, I didn't try it out...)

HTH

Tom

[chelbin]

Or alternatively you could set up the workgroup and security options in access (tools->security) and allow the user only to insert records on that table and not to view them.