Hi,
Im using a dlookup query and it gives a null value everytime.
DLookup("[N_seats]", "Allocation", "[M_Name] = '" & Me.str2 & _
"' AND [A_date] = #" & Combo33.Value & _
"# AND [A_time] = #" & Me.str1 & "#")
A_date: date type
A_time: time type
Combo33.value is a date and...