subforms

[mate]

I have an unbound form with with three subforms in it.
Each subform is a separate query. The query results for
all three are based on the same parameter (vendor id). Is
there a way to have a combo box at the top of the form
where i could choose the vendor id and have it control the
output of the three subforms? any help or direction would
be great. have a great weekend all. mate

 

[Shelley]

you could try an 'AfterUpdate' event on the VendorID combo
box to force a requery of each subform.

OR - based the subforms on queries that use the
criteria '[vendorID]= forms!mainForm!VendorID'

hope that helps

Shelley