Linking a ComboBox with a text box?

[Cheney]

I have a table with several fields set up. The first field is Product #
(AutoNum) and the last field is Unit Price. I want to create a form with a
combo box where the Product # can be selected from a list, and once selected
the Unit Price (corresponding with the Product #) is automatically displayed
in a separate box.
Im not sure if the second box (to display the Unit Price) would need to be a
text box, or ComboBox, or what.
Can anyone tell me if this is possible, and if so, how I do it.
Thanks.
Cheney

 

[scubadiver]

The combo box should have a query as a source. One column is the product,
the second column is the price. A text box can be used to store the price.

Make the width of the 2nd column 0cm. In the 'after update' event of the
combo insert the following

textboxname = [comboboxname].column(1)

I think that should work.

 

[scubadiver]

Having said that, prices and products is a delicate issue especially when
prices change. Recording such information in a table is dangerous (IMO!)