hotkey to next record

  • Thread starter Thread starter doco
  • Start date Start date
D

doco

I want to be able to go to the next record using the keyboard. How is this
done?

TIA
 
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.

hth-

Betsy
 
It is a form|subform. I want to advance the form from the subform
(customer:orders) after finishing an order for a customer. hotkey --> next
customer.

ArrowKeys, PgDn does not work. No combination of shift,alt or ctl helps
either. Haven't been able to find info either.
 
Try Ctrl-Tab to return to the customer form. Then use PgDn.

Betsy
 
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.

Ask a Question

Similar Threads


Back
Top