bmhuettinger
Registered User.
- Local time
- Today, 15:33
- Joined
- Jul 28, 2017
- Messages
- 59
I use DLookUP all the time - that's why it's particularly frustrating that I can't get this one to work.
It appears as a control in a Textbox on my form "DailyReviewForm". I want the textbox to be populated with the data from the field "MFGPart" which appears in the table "tbl_StockProgramParts". I want the lookup to be based on the (current) Form field "CustomerPO" which corresponds with the table field "POPart#"
=DLookUp([MfgPart],"tbl_StockProgramParts","[popart#]"=[Forms]![DailyReviewForm]![CustomerPO])
I've tried this many ways, many times. The field names are all spelled correctly. I don't know what else to do, though I feel it's something very silly that I'm doing wrong
It appears as a control in a Textbox on my form "DailyReviewForm". I want the textbox to be populated with the data from the field "MFGPart" which appears in the table "tbl_StockProgramParts". I want the lookup to be based on the (current) Form field "CustomerPO" which corresponds with the table field "POPart#"
=DLookUp([MfgPart],"tbl_StockProgramParts","[popart#]"=[Forms]![DailyReviewForm]![CustomerPO])
I've tried this many ways, many times. The field names are all spelled correctly. I don't know what else to do, though I feel it's something very silly that I'm doing wrong