DLookup in nested subforms

[MICHELE]

Can anyone tell me, please, why my DLookup doesn't work using the on Click of my control button?
My control is on a form that is opened from a subform. This is the code I put in my form's code:

If (DLookup("[drivingHolidays]", "T_miscDates", "[dateDate] = " & Me.lboDateDate)) = True Then
MsgBox "Driving Holiday"
End If

I've searched a lot of different forms and haven't really found anything to help. Thank you!

 

[doran_doran]

spelling...

hi there,

IIF with two ii's so it should be iif

good luck.


sample syntax:
=DLookUp("[field1]","tbl_Region","[field1] = '" & [field2] & "'")