I am trying to do something that seems very easy but with no success.
I have 2 tables: Table1 has a field product. Table2 has a field product, productfamily, etc.
I have a bound form with a combo box that is controlled with table1.product. When the user selects the product from the list in the combo box I want the next field in my form to show the cooresponding productfamily for that product that was chosen.
I have tired this: On the form in the combo box that list the products I have an AfterUpdate event that says me.combo2.requery
Then for the second combo field (which I want the product family to display in) I have set up a query on the row source property. But it is not working. I may not be setting up the second combo box correctly or the query might not be right.
I can select my product from the first combo field on the form but the second combo box just displays a blank.
I am totally new to Access 2007 and I am OK at Access.
I appreciate your time and help.