Cascading Combo Boxes

[cbramsey]

First Off I would like to say thank you to everyone who has helped over the last few weeks with certain issues.

1. I have a query named Active_BA (This pulls active owners from a linked database table)
a. BA_Number
b. BA_Name

2. I have a table named Trades
a. TradeID - Autonumber
b. BA_Number
c. BA_Name
d. Well_Number
e. Well_Name

3. I have a Query called TradesWells (this query populates Wells that are associated to BA_Numbers)
a. Well_number
b. Well_Name

I have a form to populate the Trades table with the following fields

BA_Number - This is a Combo box that pulls from the Active_BA query, it has 2 viewable columns with the BA_Number being the bound column
BA_Name - I have VBA code written to pull column two from the above combo box
Well_Number - I want this to pull from the TradesWells query, but I need this query to use the BA_Number from the first combo box to the criteria), and be able to select multiple values
Well_Name - once i get the combo box for Well_Number figured out, I will have the well_name populate from the 2nd column of the combo box

I have the TradesWells Query look to [Forms]![Trades]![BA_Number]



I thought this would be relatively simple and I am hoping that it is just some VBA code that I am not considering that needs to be done

Thank you again

[orange]

see these older free videos fro Datapig.
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

[cbramsey]

the Requery command, I can't believe i left that out. Thank you, it is always something easy like that.

[orange]

Happy to help.
Datapig has a lot of good video tutorials.