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

[browninaz]

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]

Nevermind. Thanks for all who looked at this post. I found the answer.

=DLookUp