Open form on blank record (1 Viewer)

statsman

Active member
Local time
Today, 03:59
Joined
Aug 22, 2004
Messages
2,088
Is it possible to open a form on a blank record without setting the form to Data Entry?
I would like to open the form on the first available blank record, but using the record selectors, allow the user to go to other records for editing.
For reasons that would take a great deal of typing to explain, this would be the best possible solution to the problem at the present time.
Edit: Using Access 2007
 

June7

AWF VIP
Local time
Yesterday, 23:59
Joined
Mar 9, 2014
Messages
5,424
Code would move focus to new record row. One way:

DoCmd.GoToRecord , , acNewRec

Put that in form's Open event.
 

statsman

Active member
Local time
Today, 03:59
Joined
Aug 22, 2004
Messages
2,088
Thanks June, I will give it a try.
Before people start typing, there will never be more than 17 records in this table.
 

Users who are viewing this thread

Top Bottom