How do i lock a product description to a part number

D

Dave

I want to be able to lock a product description to a part number, so when the
part number is entered on a form the description will be displayed automaticly
 
J

John Vinson

I want to be able to lock a product description to a part number, so when the
part number is entered on a form the description will be displayed automaticly
Click to expand...

Where in your Tables is this information stored?

I'd suggest having a Parts table with fields PartNumber and
ProductDescription (and perhaps other fields). On your Form, put a
Combo Box based on this table, bound to the PartNumber field in the
form's table. The combo's RowSource should be a query selecting the
part number and the description.

Put a Textbox on the form with a controlsource

=comboboxname.Column(1)

using your actual combo box's name; the (1) means display the *second*
column of the combo's row source query, it's zero based.

John W. Vinson[MVP]
 
J

John Vinson

I also need to do the same in a table, will the same method work.
Click to expand...

No. But then you should never under any circumstances use a Table
Datasheet for routine editing or viewing of data anyway, so it doesn't
matter - just use a Form.

John W. Vinson[MVP]
 
Top