I am trying to base a query criteria date field on a form's text date field. When I run the query it does not pick up the date - it shows a single row and the record cells are empty - no date showing.
I have checked that the table and the text field are set to the same date format. What am I doing wrong?