Displaying Information From A Seperate Table

[matethreat]

Hello,

I have a form which I enter information about a job. One piece of information is an Item Number.

After I enter that item number I want the form to look up in another table the description of that item number and display it on the form.

Both tables contain the item number.

For example:

The forms table:
ItemNumber
Quantity
Price

The master table:
ItemNumber
Description

Now after I type the Item Number on the form I want to display the description from my master table, in a text box.

Any Ideas??

 

[PHV]

Take a look at the DLookUp function:
DLookUp("Description", "[master table]", "ItemNumber='" & Me!ItemNumber & "'")
If ItemNumber is defined as numeric, get rid of the single quotes.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TheAceMan1]

matethreat . . . . .

Try this in the [blue]AfterUpdate Event[/blue] of [Item Number]:

[blue]Me!TextBoxName = DLookup("[Description]", "MasterTableName", "[Item Number] = " & Me![Item Number])[/blue]

See Ya! . . . . . .

 

[matethreat]

Thank you guys for your responses, they helped me solve my problem.

Aaron