Hi All,
I'm on tabbed form [FORM1] and I'm looking to requery (refresh) the recordsource on Tab A, subform A, based on activity (e.g. checking a checkbox) in Tab B, Subform B.
Does anyone know how to use VBA to force a refresh on a subform's recordsource without that subform being currently visible to the user?
:banghead:
Thanks in advance!
John
I'm on tabbed form [FORM1] and I'm looking to requery (refresh) the recordsource on Tab A, subform A, based on activity (e.g. checking a checkbox) in Tab B, Subform B.
Does anyone know how to use VBA to force a refresh on a subform's recordsource without that subform being currently visible to the user?
:banghead:
Thanks in advance!
John