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."