Question about tab controls, subforms and master/child fields (1 Viewer)

[dkmoreland]

I have a form with a tab control that has 3 pages. The master job number is entered on the first page, along with some other info.

I have subforms on each of the second and third pages on the tab control. I have the master / child fields set to populate the job number field on the subforms.

My question is this - how do I go about saving the record entered on the first page so it will populate the linked fields on the second and third pages? It works if I navigate away from the record on the first tab and go back to it but that is clunky.

Should I use DoCMd.Save somewhere on the form or the first tab page? Which property would I use to do that?

Thanks in advance.

 

[Minty]

You can use

If Me.Dirty Then Me.Dirty = False

in the OnChange tab control event to save the changes in the current record as soon as you select another tab ?

 

[JHB]

Use the event "On Change"

Private Sub YourTabControl_Change()
  If Me.Dirty Then Me.Dirty = False
End Sub