Single lookup combo box for multiple subtabs

[PaulA]

Hi, all -

Is there a way to have a single lookup control box (or some similar functionality) that look up records for subforms in multiple subtabs in a navigation form? I'm needing to break up a tab control from a single form into individual subtabs in the navigation form tab and it would be great to retain the single lookup instead of a separate one for each subtab.

The one thing is that I don't know here to put it as navigation forms don't have headers and such...

Thanks.

 

[Ranman256]

you only need 1 subform. When the user clicks a tab, you change the query in the subform.
this stops the sys from running out of memory due to all the subforms,
make the data faster,
and you only need filter 1 subform.

sub cboFilter_Afterupdate()
if isNull(cboFilter) then
   me.subform.form.filterOn =false
else
   me..subform.form.filter = "[ID]='" & cboFilter & "'"
   me.subform.form.filterOn =true
endif
end sub