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:
Expand|Select|Wrap|Line Numbers
- Private Sub CPTcode_AfterUpdate()
- Charge = DLookup("Charge", "Q_CPT-phys test1", "CPTcode= '& CPTcode'")
- End Sub
Please Help
Adigga1