Update subform with data from popup window.

[noone]

I'm making a sales order database similar to Northwinds but with a slightly
different form. The tables are the same.

The 'Sales Orders' form has a 'Line Items' subform.

I've added a 'Add Item' button to the master form 'Sales Orders'. Clicking
the button will bring up a popup window'Search' ( a continuous form).

A combo box on the 'Search' form header lets the user select which category
of product he wants to choose from. The continous form recordsource will
requery to show only the products of that category.

To add an item to the Sales Order, the user selects the product (record) in
'Search' and clicks the 'Add to Sales Order' button on the 'Search' form
footer. The item will be added to subform 'Line Items' and the 'Search'
window will close.

How do I tell the subform to add the new item?

[Pieter Linden]

Tangential answer... why not have an unbound combobox on your form and
use that to filter for the type of Product... then you can do it all
the easy way... This sounds like a lot of unnecessary work. What
will this buy you that filtering one combobox based on the contents of
another won't?