So here are 2 tests I have tried:
CODE
MsgBox DLookup("[Clinic Name]", "tblConsultAlias", "[Service Name] = '"& Forms![frmAddRecord]!ConsultPullTitle & "'")
MsgBox DLookup("[Clinic Name]", "tblConsultAlias", "[Service Name] = 'COMMUNITY CARE-IC EMG/NCV-636A8'")
The first line does not work and returns an error 'Invalid use of Null'.
The second works fine and returns 'EMG/NCV' like it should. The verbiage 'COMMUNITY CARE-IC EMG/NCV-636A8' is located in the ConsultPullTitle field of the frmAddRecord form. So something is wrong with how I am using Dlookup with either a variable or referring to the field for input.
Thoughts?