Retrieving data into a form

[Guest]

I would like to input a part number onto to a form. After entering the part
number, I would like to populate the from with the nomenclature, serial
number, description, etc... for that specific part number. How do you do
this?

Thank you.

 

[pietlinden]

I would like to input a part number onto to a form. After entering the part
number, I would like to populate the from with the nomenclature, serial
number, description, etc... for that specific part number. How do you do
this?

Thank you.

create a combobox for the part number. Set the column count to the
number of fields you want to autopopulate (0r more).

then you can set the control source for the textboxes to
cboMyCombo.Columns(1) etc
the columns collection is zero-based, so you'd use
cboMyCombo.Columns(0) to .ColumnCount-1

 

[John Vinson]

I would like to input a part number onto to a form. After entering the part
number, I would like to populate the from with the nomenclature, serial
number, description, etc... for that specific part number. How do you do
this?

Thank you.

If you're trying to copy all this information from one table into
another table... DON'T. It's neither necessary nor appropriate to
store data redundantly.

If the Form is based on the Table containing this information, use the
Toolbox Combo Box tool (with the magic wand icon selected) and choose
the option "Use this combo box to find a record".

If you want to do something else... please explain a bit about your
table structure (where is this data coming from? What's the
recordsource of this Form?); I'm sure it can be done.

John W. Vinson[MVP]