Hello,
I have having trouble using the DLookUp function in Access.
I have a form: "frm - Finish Specs"
A subform within this form "qry - Finish Specs - Final Product Chemicals subform1"
Within this subform I have a bound set of values in a text box called "tblMasterChemicals.1_CAS_#".
I would like to take this bound value and lookup a value in a separate table titled "tblHS14722".
It's matching value will be found in the field "CAS#" in table "tblHS14722." When it finds the same value I would like it to return in the text box "Text94" the value in "tblHS14722" in the "Category" field.
Here is what I am typing into the Control Source of the Text98:
=DLookUp("[Category]","tblHS14722","tblMasterChemicals.3_CAS_# = '" & "CAS#") & "'"
Any help would be greatly appreciated. Or if you need more information. I have also attached a screenshot in hopes of clarifying too.
Thanks you.