I have a form that we input Vendor insurance information. My corporation has
7 companies. Each of the 7 companies has their own Vendor list. I have a
combo box named Vendor whose record source is a query from a UNION query. So
in this UNION query I have all 7 company's Vendors pulling on one query. From
this query I have another query which filters for a specific company Vendor
list....In the criteria of column 'company' I have [company code?].

On a continuous form I have the combo box Vendor. The end-user clicks on this
combo box and a filter box opens asking for [company code?]. The end-user
might type 'BAS'. The query works to only show the Vendors for company BAS.
This works fine; however on the continuous form the next record being entered
might not be for company BAS. The combo box is still only showing for company
BAS. How do I get the combo box to requery on a new record being added?

Thanks.

--
Message posted via http://www.accessmonster.com