Tabbed forms

[Guest]

I'm writing a "membership" database in Access for a sports club. It has a
3-page tabbed form for data entry. Part way down page 1, having entered data
in a field, when I hit the Tab key to move to the next field, I get a message
that I can't save the record because an entry is required in a field on page
3. If I go to page 3 and enter data in the indicated field and come back to
page 1, all is well and I can carry on and eventually save the record when
I've completed the data entry. Or, I can go to page 3 first and fill that in
before I enter data on page 1. All the relationships seem to be right on the
reltionships screen and the tab order is set for each page on the 3 tabbed
form separately, so how can I get to fill in the three pages one by one
instead of
having to jump from one to another?

 

[Guest]

Is it because that field on page three is the foreign key field for the
relationship?

 

[Guest]

Try changing the Cycle property of the form to 'Current Record'. The problem
might be that when you tab off the control on page 1 you are in fact
inadvertently trying to tab to another record before a value has been entered
in a required field on page 3. The message you are getting certainly
indicates that an update operation is being initiated. If this is the case
then changing the Cycle property should prevent it as the focus will be
cycled within the current form until you expressly move it to another record
or close the form.

Its possible that, as SD suggests, you are attempting to insert a row into a
referencing table before a matching row has been inserted into a referenced
table. This could be the case if the pages contain subforms bound to related
tables. I'm dubious about this, however, as data error would then be the
lack of a matching row in the referenced table, not the lack of a value in a
required field, so the message would be rather different.

Ken Sheridan
Stafford, England