cbo box based on main form - query help

[hlkelly]

I have a main form with several subforms on tabs. One of the subform has a subform of its own.

Main form = shows
Tab #1:
Subform1 = Orders
Subform2 = OrderDetails
Tab #2:
Subform3 = ShowInventory

Subform3 lists a number of products that are brought to the show.

Subform1 lists the name, address, etc. of each purchaser and Subform2 would list the item (from a selection of related items) and the quantity they purchased.

On subform 2 (Tab#1), I would like to have a combo box that is based on the list of related inventory for each show. So when a sale is added, the drop down box will only reveal a list of the inventory that was brought to the show and not the entire list of inventory available company-wide.

Can anyone help? I feel like I've tried everything...but no such luck so far.

Thanks!

Heather

 

[dhookom]

The row source for the combo box would be the same query as the record source of subform3. You may need to set a criteria in the query and re-query the combo box in some event.

Duane
Hook'D on Access
MS Access MVP