syntax error in query expression in MS/ACCESS 2016 (DLOOKUP)

I am consistently getting this error and I can't find any reason. can anyone help?

Screen-Shot-2016-10-16-at-09.52.40.png
João serras-pereiraAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Ryan ChongConnect With a Mentor Commented:
try:

t = Dlookup('tempoCriticidade", "Q06_zCT_criticidadeTempo", "criticidadeTicket = '" & Me.fld_criticidadeTicket & "' " )

or

t = Dlookup('tempoCriticidade", "Q06_zCT_criticidadeTempo", "criticidadeTicket = '" & replace(Me.fld_criticidadeTicket,"'","''") & "' " )
0
 
João serras-pereiraAuthor Commented:
the first one worked OK! Thanks!
0
 
Ryan ChongCommented:
cool, glad that it helps cheers
0
 
João serras-pereiraAuthor Commented:
thought it was closed....
0
All Courses

From novice to tech pro — start learning today.