data base

[bob56tec]

I have created a form and have also a data base that has parts with part
numbers, my Issue is I would like to be able to start entering a part number
in my form utilize type ahead and have the cell select the part number and
the price and the discription from the data base, then enter it in my form.
this is to be used by our field service personel.

 

[Arvin Meyer [MVP]]

Use a combo box and the column propert of that combo. The row source of the
combo should be something like:

Select [part number], price, description From tblParts

now add a couple of textboxes to the form and set their controlsource to:

=MyCombo.Column(1) and =MyCombo.Column(2)

for the second and third columns. That way, you can still view and print the
price and description without having to store it twice.