before update event > save record?

[krisleech]

I have a message box pop-up on the before update event of my form. Only problem is i use a tabbed object with 3 tabs, the fields on one tab and two sub forms on the other two tabs.

When i move onto the tabs with the subforms the on update event is triggered and the pop-up displayed.

Does anyone know how to prevent this, really i want the records to be saved when the user moves onto the next record or closes the form without saving.

The subforms are visually part of the same record as the fields on tab 1, so i wish to save the fields and subform changes all at once.

Many thanks in advance Kris.

 

[krisleech]

I tried creating a fourth tab with some fields in and when tabbing onto this tab access does not try to save the record (ie. by triggering beforeupdate event). It is only when you tab onto a tab that contains a subform.
For some reason accessing a subform requires access to save the record.

Regards kris.

 

[Rich]

Access will save the Parent record as soon as you leave the Parent form

 

[krisleech]

But i am not leaving the form, i am just going to the next tab on a tabbed control. Going from tab to tab does'nt cause access to save the record. It is only when i go onto a tab that contains a subform.

 

[Rich]

Because Access will set focus to the subform when you click on the tab

 

[krisleech]

I see.
So is there any way to prevent focus going to the subform, would an invisible control set to first in the tab order work or is it just the fact that the subform is displayed that the parent form looses focus?

thanks Kris.