I'm trying place a combo box on a form that contains a list of options - when someone chooses an option, I want another combo box to display a certain value. For example: I choose shoes from the first drop down list and the second drop down list displays the cost of the shoes. I use Access 2000 and have created forms before. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Combo Box
- Thread starter smoot
- Start date
in the row source for the 2nd combo box, make a query based on your shoe price table.
in the criteria for ShoeID (or whatever you're using) put
=forms!cboShoe!ShoeID
where cboShoe is the name of the first combo box and ShoeID is the name of the ShoeID field in the first combo box
in the first combo box AfterUpdate, put
me.cboShoePrice.requery
where cboShoePrice is the name of the second combo box. this will refresh the list that comes up in the second combo box after the user chooses something from the first one.
g
in the criteria for ShoeID (or whatever you're using) put
=forms!cboShoe!ShoeID
where cboShoe is the name of the first combo box and ShoeID is the name of the ShoeID field in the first combo box
in the first combo box AfterUpdate, put
me.cboShoePrice.requery
where cboShoePrice is the name of the second combo box. this will refresh the list that comes up in the second combo box after the user chooses something from the first one.
g
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question