Saving records on a form with subforms

[Maureen]

I have an Access 2002 database - running in multi user
envir. on Wind2000 server.

I have several forms which have tab pages - there is a
subform on the tab pages. In order to ensure records are
getting saved, when I click on new tab/page, I run a
macro which has: RUNCOMMAND - SAVERECORD.

Question I have is - what record will be getting saved?
All records on the master form (which would include all
subforms)?

THANKS!

 

[Allen Browne]

Access saves each form's record independently of the others.

If you are in the subform and click the tab contol on the main form, Access
will save the subform record *before* it allows the focus to move back to
the main form. Likewise, if you are on the main form and click anywhere in a
subform, Access will save the main form's record before it allows focus to
move into the subform.

If you force the 'save record' in the Change event of the tab control, it
would have the effect of saving the main form record only, and then only if
you were editing the main form record at the time. It is probably not
needed.

If you used the Click event of the Page, it does not work at all. This event
does not fire when changing tab pages.