I am wondering if there is a way to load one category from an access database into a combobox and when that item is selected the corresponding price is loaded into another textbox from the database. I have been trying to figure it out all day and have been unable to do so. Your help is appreciated. Thanks, Andy
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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Combobox database controls
- Thread starter Andwise
- Start date
If the table behind the combo was something like
CategoryPrice (CPID, Category, CatPrice)
the combo statement would be something like
select CPID, Category, CatPrice from CategoryPrice order by Category asc
and combobox would be set to only show category
the afterUpdate sub on combobox something like
Forms!Form1!PriceControl = Forms!Form1!CategoryCombo.Column(2)
Ben
+61 403 395 052
CategoryPrice (CPID, Category, CatPrice)
the combo statement would be something like
select CPID, Category, CatPrice from CategoryPrice order by Category asc
and combobox would be set to only show category
the afterUpdate sub on combobox something like
Forms!Form1!PriceControl = Forms!Form1!CategoryCombo.Column(2)
Ben
+61 403 395 052
- Status
