Confused about 3 combo boxes

I'm creating a simple inventory database access 97 -
combo box 1 is prod name
combo box 2 is prod description
Combo box 3 is price

I want to pick a name in combo box 1 and then have combo 2, 3 to fill in
automatic.
So far I have a query running products and transaction table in all 3 combo
boxes - taking names and price from transaction table and description from
the product table. I have combo 1 named product name and combo 2
[ProductName].(column).(1) - This works. I choose product name and the
description fills in - but I don't know how to get the price to fill in. I
am new and I have tried looking at the example mvps access form 0028 and this
does not help because I need to see how this is done with more than 2.
Any help is appreciated -

just as you did to combo 2 do to combo3
[ProductName].(column).(2)
but instead of selecting column 1 select column 2 or what ever the location
of the field price in the source of combo product name.
if you didn't add the field price to the source then you need to do so.


"esparzaone" wrote:

I'm creating a simple inventory database access 97 -
combo box 1 is prod name
combo box 2 is prod description
Combo box 3 is price

I want to pick a name in combo box 1 and then have combo 2, 3 to fill in
automatic.
So far I have a query running products and transaction table in all 3 combo
boxes - taking names and price from transaction table and description from
the product table. I have combo 1 named product name and combo 2
[ProductName].(column).(1) - This works. I choose product name and the
description fills in - but I don't know how to get the price to fill in. I
am new and I have tried looking at the example mvps access form 0028 and this
does not help because I need to see how this is done with more than 2.
Any help is appreciated -