Tab Controls and Next Record

S

Scott

I have a form with a TAB Control on it. I have fixed the form so that as I
exit the last field on the first page of the TAB Control it goes to the first
field on the second page of the TAB Control. When exiting the last field on
the second page of the TAB Control it goes to the first field on the same TAB
Control page and starts a new record. However, while I do want it to go to
the next record I also want it to go back to the first field and first page
of the TAB Contol. Any thoughts?

Access 2003 database
 
L

Linq Adams via AccessMonster.com

In Design View, for the form, goto Properties - Other and change the Cycle
Property from "All Records" to "Current Record."
 
Top