Run-Time Error 3075

[crisb184]

Please Help!!!!

I am new to access and have been staring at the same Run-time error for 3 days (pathetic I know). I cannot for the life of me figure out why it does not like my Dlookup. Esentially, I want and After Update event in my combo box to populate a Rich text textbox in my form. After reading DLookup is the easiest way to make this happen.

Here is my code:

Me.emailbody.Value = DLookup("[Escalation_1]", "Status_Emails", "Status_Emails.Status =" & (cboStatus.Value))

My error reads: "Syntax error (missing operator) in query expression 'Status_Emails.Status = LOCATION NEED MORE INFO'.

LOCATION NEED MORE INFO is the value in my criteria cbostatus.value.

Any Help would be amazing.

Thanks Cris

 

[pr2-eugin]

crisb184, Welcome to AWF..

Try

Me.emailbody = Nz(DLookup("[Escalation_1]", "Status_Emails", "Status = '" & Me.cboStatus & "'"), "NA")

 

[crisb184]

Thank You Paul!

 

[crisb184]

Much appreciated

 

[pr2-eugin]

You are welcome..