look up value for a form

[Rpettis31]

I have a form that has a field for an item number and another for description.
I have two tables customer and item master.
I wish to have the description populate upon entering an item number.

 

[Al Campagna]

Rpettis31,
I'd suggest a combo box (ex. cboItemNo) with 2 colums... ItemNo and
Description from your ItemMaster table.
Set the combo's LimitToList =Yes to prevent illegitimate ItemNos form
being entered.
Bind that combo control to ItemNo.

For whatever ItemNo you select, an unbound text control, with a
ControlSource of...
=cboItemNo.Column(1)
will always display the correct Decscription, for the ItemNo selected.

Save the ItemNo through your "bound" combo box, but just "display" the
Description.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."