Text Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am making a form for inspecting parts. To hurry things up I would like to
enter a product code in a text box. Then have the Product name description
and department name pop up in the next three text boxes automatically. If
anyone knows how to do this I would appreciate any help.

Donbenz
 
One way, look at this link on "Fill Fields automatically on form based on a
control's value"

http://www.mvps.org/access/forms/frm0009.htm

I would use a combo, where the control source of the combo will incluse all
the fields that you need

Select [product code],[Product name], [description],[department name] From
TableName

Create 3 text boxes on the form, for each of the wanted data, and in the
control source of each one of them write

Product name text box
=[ComboName].Column(1)

description text box
=[ComboName].Column(2)

department name text box
=[ComboName].Column(3)

Note: the column count start with 0
 
Back
Top