requery combo boxes on sub form

[david.paton]

I want to requery combo boxes on sub forms to a main form.

I have the code in the on current event of my main form

Private Sub Form_Current()
Me.Form.Requery
Me.frmCarerAvailabilitysubform.Requery
Me.tblCarerNotesSubform.Requery
Me.tblChildSubform2.Requery

End Sub


However, will this requery combo boxes within the subform?

 

[arnelgp]

You don't requery the main form. It will tossed you back to the first record.
you must explicitly requery the combos.