[krs1716]

I am in the process of creating a database for work. The database will be used my people who have used access before, but they have never used a form in a database (everthing operated off of several tables).

Currently, I am using a form to input the data into the tables. My form has five pages that include various subforms. However, in order to tab from one subform to the next or one page to the next, I have to use the Ctrl + Tab function. I would prefer, for the sake of the users, to be able to just use the Tab button to move from subform to subform and page to page. Is there a way to program that into the database?

[OBP]

As far as I know there is no "On Tab" event, so you can't use VBA to that.

[krs1716]

Is there a reason why the information would be erased from sight when the tab is pressed after the last field on a page? This is happening in my database. The good news...if I close the form and re-open it, the information is still there.

[OBP]

It sounds like you are "Tabbing" to somewhere that has no data.
Have you looked at the Form's "Cycle" property, you can prevent it moving from the current record by setting it to Current Record.

[krs1716]

The cycle property is set to Current Record. It's only when I tab after the last field on a particular page in the form.