The answer depends on your screen. If you are in datasheet or tabular
view, the down arrow key will work for you. If you are in a form
showing just a single record, PgDn will do it. Be aware that you will
move to a new record in the field that you were in when you pressed the
key.
Another trick is to put a command button on your main form to go to the new
record. Set its Caption property to (say):
&New Record
Now Alt+N takes you to a new record in the main form, even if you are in the
subform.
The button's event procedure would be something like this:
If Me.Dirty Then Me.Dirty = False
If Not Me.NewRecord Then RunCommand acCmdRecordsGotoNew
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.