Requery subform when main cbo changes

[johnnybwis]

I have a subfrom that runs a query on a cbo in the main form (Pick customer on main form and subform cbo choices are products associated to that customer) but need the subform to requery if the user goes back and changes the mainform cbo. Currently there is a requery on subform on enter and exit which kinda works.

 

[papparuff]

In the cbo's After Update Event add the following (I'll call the subform frmProduct_Sub)

Private Sub cbo_AfterUpdate()

frmProduct_Sub.requery

End Sub



John Ruff - The Eternal Optimist