Date

[idowu100]

where = where & " AND [Date Restriction Imposed]= #" + Me![DateRestrictionImposed] + " #"

I have typed this code on my search query but cannot get it to display the information. It seems to be picking everything in the table.

Is there something wrong with the syntax?

 

[Rich]

You have to convert the dates to US format when using strings
"And [Date Restriction Imposed]= #" & Format([Date Restriction Imposed], "mm dd yyyy") & "#"