I have a form where a user enters a date that I will then base a query
on. In the past, I have simply placed Forms![Form_Name]![Field_Name]
into the criteria for a query and it runs as long as the form is open.
The recordset is then filtered based on what was entered in the form.
However, this strait forward approach seems to break when the form
value to be passed to a query is a date. I have a format and input
mask of ShortDate placed on the form. It is an unbound field. The
recordset always comes up empty because I'm guessing that it is reading
the date on the form as a string instead of a date.
How do I convert my form value to a date in the criteria selection for
a query so that it will run like any other selection criteria I have
handled this way?
Thanks!