Tab Controls and Next Record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott - 11 Apr 2008 20:53 GMT

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

Reply to this Message

Linq Adams - 12 Apr 2008 00:48 GMT

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

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message