Populating a text box control with data from a field in a table (1 Viewer)

browninaz

Registered User.
Local time
Today, 12:44
Joined
Oct 26, 2012
Messages
88
Hello everyone,

This is probably an easy question for most. I have created a multiple items form from a query that I created from tblPurchaseDetails. In this query, I have a field EquipmentDetailsNum that is in the purchase details table that derives from tblEquipment, but I would like to populate a text box control with the name of the equipment, not the number. I have been able to do this by inserting a combo box, but I don't want to use a combo box in the form.

Thanks to all who know more than me.
 

browninaz

Registered User.
Local time
Today, 12:44
Joined
Oct 26, 2012
Messages
88
Nevermind. Thanks for all who looked at this post. I found the answer.

=DLookUp
 

Users who are viewing this thread

Top Bottom