Open to new record

[Bobcoop103]

I have access 2007 on a Win 7 computer, I have many entries and enter new records daily, I have to page down through many pages to get to New, is there some way that I can open to New every time I open access?

Thanks, Bob

[pbaldy]

Presuming you still want the old records available for viewing, use

DoCmd.GoToRecord

in the load event of the form, with the appropriate arguments.

[ketbdnetbp]

Bobcoop103 -

If you are entering the records via a form, you could set the DataEntry property of the form to True. However, before doing so, you may want to make a copy of the form, in case you need to view all records at some point.

All the best,

Jim

[ketbdnetbp]

Sorry Paul - Didn't see your post before replying. Jim

[pbaldy]

Sorry Paul - Didn't see your post before replying. Jim

No problem! By the way, rather than use a copy for viewing existing records, I'd use a single form and control the mode with the appropriate argument of OpenForm. I'm lazy, and don't want to maintain two forms when one will do.

[ketbdnetbp]

Paul - You're absolutely correct. Thanks for the reminder. Jim