Hey there!
I have a very simple (right now) User Form. The top portion has the User select a part number in a combobox (called cmbPartNum.
The next section contains Basic Part Data (that is stored in a table). I have several text boxes in this section that I want to create lookups for. The lookup should take the part number, and look up a field in the table (Base Number) and return it to the text box (txtBase8).
I tried this code in the Control Source of my Text Box (txtBase8): =DLookUp([dbo_tblDM2Import]![Base Number],[dbo_tblDM2Import],[dbo_tblDM2Import]![Part Number]=cmbPartNum.value
I get #Name? as the result, no matter what Part Number I choose.
Thanks in advance!