look up value for a form

R

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto-populate form field 3
Look up 7
How to get field value from last related record? 3
form field 1
Assigning Data to Multiple Fields with a Combo Box 2
Format issue. 1
query issue 5
Running a Query 3

Top