move automatically to next record

[Guest]

I have created a form where the last control will be required to anwser. I
want to take advantage of this feature. I want my form to move to the next
record right after the last control is answered. How can I make this happen?
Is there a macro that would help me do this?

Miguel

 

[Rick B]

When I make entries in a form, I simply press PAGE DOWN after I make the
last entry on the screen. This adds the record and moves you to a new blank
record.

 

[Guest]

Hi Miguel
A way to do this is use the 'DoCmd.GoToRecord , , acNext' on the on exit or
lost_focus event of the last control so when the user presses enter or tab to
leave the control the system runs the command and moves to the next record.

A way I found to help me on things like these was to utilise the wizards in
access, for this one you could place a go to next command button (via the
wizards) onto the form and then copy the vba (between the 'on error goto' and
the 'exit' entries into your control on the event you want it to happen, this
way you could have a control that when you leave it to opens a new form or
closes its own form.
The key is, if you have time, to play on a test system.

Mike J. Soames

 

[tina]

if you set the form's Cycle property to "All Records", when you leave the
last control in the form's Tab order by pressing Enter or Tab, the system
should automatically move to the next record.

hth