Move to new record

G

Guest

I have a form design with a subform displayed in Data Sheet view. When this
form is opened i would like the user to be able to go directly to the next
Blank row in the data sheet for entering a new record. How can this be
achieved and thanks for any advice.
 
T

tina

try the following code in the *subform's* Load event procedure, as

On Error Resume Next
DoCmd.RunCommand acCmdRecordsGoToNew

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Need combo box to refresh when moving to new record 2017 1
Generating a new Record 14
VBA to automatically cut, paste entire row based on date input and delete row 0
Unremovable horizontal scroll bar on subform 1
Open a record on a form depending on the record of another form 5
Can't go to new record 1
Button actions on form... 3

Top