Hey,
I have a dlookup function for an unbound textbox. Th problem is that the function doesn't return the correct value. This is my syntax:
DLookUp("[Available]";"tblPlanning";"[Name] =" & [txtName] & " And [Date] =" & [txtDate])
The controls "Name" are numeric and the controls "Date" are Date/Time
The syntax should be correct for a multiple criteria, but it doesn't work. Is it because I use a Date/Time control as a criteria? Normally a Date/Time criteria should be between #date#
Does anybody know how I should write the criteria?
Thanks for your help.
Best regards,
Dries
I have a dlookup function for an unbound textbox. Th problem is that the function doesn't return the correct value. This is my syntax:
DLookUp("[Available]";"tblPlanning";"[Name] =" & [txtName] & " And [Date] =" & [txtDate])
The controls "Name" are numeric and the controls "Date" are Date/Time
The syntax should be correct for a multiple criteria, but it doesn't work. Is it because I use a Date/Time control as a criteria? Normally a Date/Time criteria should be between #date#
Does anybody know how I should write the criteria?
Thanks for your help.
Best regards,
Dries