Hi, new to the forum and fairly new to Access. Thanks for taking the time to help me on this issue. I've been searching and searching and cannot figure it out alone. :banghead:
I have a form with a text box control where I am trying to perform Dlookup function. This is what I put in the Control Source:
=DLookUp("[Par Fee]","Medicare Fee Schedule - NON FACILITY - 2017","[Procedure Code w/Mod]='" & [CD1])
I'm trying to look up the field [Par Fee] from the table "Medicare Fee Schedule - NON FACILITY - 2017" based on the value in form field [CD1] which should equal the field [Procedure code w/Mod] from the table.
According to table design, the field [Procedure Code w/Mod] is Short Text data type. In case that makes a difference.
I keep getting #Error no matter what I try. Please help me!!!!
I have a form with a text box control where I am trying to perform Dlookup function. This is what I put in the Control Source:
=DLookUp("[Par Fee]","Medicare Fee Schedule - NON FACILITY - 2017","[Procedure Code w/Mod]='" & [CD1])
I'm trying to look up the field [Par Fee] from the table "Medicare Fee Schedule - NON FACILITY - 2017" based on the value in form field [CD1] which should equal the field [Procedure code w/Mod] from the table.
According to table design, the field [Procedure Code w/Mod] is Short Text data type. In case that makes a difference.
I keep getting #Error no matter what I try. Please help me!!!!