If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to requery on new record continuous form
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 |
Thread Tools | |
Display Modes | |
|
|