Move to new record

R

Roger Bell

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
 
Top