browninaz
Ugly Data Hoarder
- Local time
- Today, 07:49
- Joined
- Oct 26, 2012
- Messages
- 88
Hello Everyone,
I have a multiple items form that displays purchases for a certain area. The purchases include items from two tables, with two different numbers. I have just learned how to use the =DLookUp function, but I would like to eliminate multiple controls on each line by using one text box control to list whatever item is listed. For example, on one line I have an equipment number, and on another line I have an office supplies number. Instead of having two text box controls per line with two different =DLookUp, I would only like to have one that displays whatever the line item happens to be.
This is the function I am using for one particular field:
=DLookUp("[EquipmentName]","[tblEquipment]","[EquipmentNum]=" & [Forms]![frmPurchasesOfficeOne]![EquipmentNum])
Hopefully I am making sense of all this.
Thanks to all who know more than me.
I have a multiple items form that displays purchases for a certain area. The purchases include items from two tables, with two different numbers. I have just learned how to use the =DLookUp function, but I would like to eliminate multiple controls on each line by using one text box control to list whatever item is listed. For example, on one line I have an equipment number, and on another line I have an office supplies number. Instead of having two text box controls per line with two different =DLookUp, I would only like to have one that displays whatever the line item happens to be.
This is the function I am using for one particular field:
=DLookUp("[EquipmentName]","[tblEquipment]","[EquipmentNum]=" & [Forms]![frmPurchasesOfficeOne]![EquipmentNum])
Hopefully I am making sense of all this.
Thanks to all who know more than me.