how is a tabbed form updated when another form alters the records

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

Guest

how is a tabbed form updated when another form alters the recordset - without
closing and re-opening the forms
 
It depends on how the form's set up.

If the various tabs simply refer to fields in the form's RecordSource, you
can requery the form:

Me.Requery.

If the tabs are actually subforms, you'd have to requery the appropriate
tabs:

Me!NameOfSubformControl.Form.Requery

Note that depending on how the subform is added, the name of the subform
control may be different than the name of the form being used as a subform.
 
Back
Top