C
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
(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