Problem Combo Boxes!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am making a database to calculate estimates for the company I work for. I
have a products table that lists all the products that has a Unit Price, Hrs
Per Item, and Margin columns. I also have a catagories table. I want to set
a catagory combo box that when you select the relevant catagory I will filter
down the products under that catagory. When I select the relevant product I
want it to pull through the unit price etc from my query and store it.

Does anyone have any ideas of the best way to do thi? It has been a while
since I used Access and can't figure out a way to do it!

Thanks!!
 
Jo said:
I am making a database to calculate estimates for the company I work for. I
have a products table that lists all the products that has a Unit Price, Hrs
Per Item, and Margin columns. I also have a catagories table. I want to set
a catagory combo box that when you select the relevant catagory I will filter
down the products under that catagory. When I select the relevant product I
want it to pull through the unit price etc from my query and store it.

Does anyone have any ideas of the best way to do thi? It has been a while
since I used Access and can't figure out a way to do it!
Click to expand...

The way I do it is to build a query or select statement as the row source of
Combo 2 using a form reference to Combo 1 as a criteria, something like:

Select ProductID, ProductName From Products Where CategoryID =
Forms!frmMyFormName![cboCombo 1]

This won't work well in a continuous form unless the categories are the
same.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top