Keep Tab Control dirty?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a non nullable field in the detail section of the MainForm.
I have linked several SubForms in TabControls with the same field.

Everything works fine if the user fills out the
non nullable field first while focus is still on the MainForm

This is not the behavior that im trying to achieve.

Is it possible to disable commiting any changes while the user navigates
thru the
tab controls?

Even when you set focus from the main form to the subform it commits changes
and starts spamming about the required field.
 
You will need to learn to work *with* the Access mindset to work around this
issue.

Typically a main form is bound to a primary table, and a subform (whether in
a tab page or not) is bound to a related table. If you have them both bound
to the same table, or the wrong way around (master in the subform, related
table in the main form), there's a raft of other issues, so let's assume you
have it the normal way.

Now, you are asking to be able to go into the main form, create or edit a
record, jump into the subform without saving the main form record, and
create the related record, while there is potentially no record saved in the
main form for this child record to be related to? Do you see the logical
problem here?

Access must process the main record before you can handle the related record
in the subform. That's how it's designed.

Of course, there is no logical problem in having a nullable field in the
main form that you set later.

Hopefully this is not a matter of storing data in the main record that is
dependent on the value(s) in related record(s).
 
Back
Top