Hello Experts,
I'm about to go grey with this dlookup statement:
I'm trying to run a dlookup statement, I have the correct expression string, etc. but when I run it under the Immediate window for testing I'm getting the runtime error.
Scanerio:
I'm calling an associated Price value (Currency) for a Code (text) from a Query in order to have an auto population in the fields; here is the code:
It only populates if i replace the & CPTcode with an actual value. This is pulling from the same Subform. Immediate window for testing I'm getting the runtime error.
Scanerio:
I'm calling an associated Price value (Currency) for a Code (text) from a Query in order to have an auto population in the fields here is the code:
Please Help
Adigga1
I'm about to go grey with this dlookup statement:
I'm trying to run a dlookup statement, I have the correct expression string, etc. but when I run it under the Immediate window for testing I'm getting the runtime error.
Scanerio:
I'm calling an associated Price value (Currency) for a Code (text) from a Query in order to have an auto population in the fields; here is the code:
Code:
Private Sub CPTcode_AfterUpdate()
Code:
[SIZE=3][FONT=Times New Roman] Charge = DLookup("Charge", "Q_CPT-phys test1", "CPTcode= '& CPTcode'")[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]End Sub [/FONT][/SIZE]
It only populates if i replace the & CPTcode with an actual value. This is pulling from the same Subform. Immediate window for testing I'm getting the runtime error.
Scanerio:
I'm calling an associated Price value (Currency) for a Code (text) from a Query in order to have an auto population in the fields here is the code:
Please Help
Adigga1