Creating a form that displays results for a certain date?

What is the process for creating a form that will return all records for a certain date?  Or rather, how can I incorporate a variable into my SQL syntax?

Preferably when a user opens this form, they would select a date and a subform would render the records that match that date.  Something along the lines of SELECT * FROM visits WHERE

Thanks in advance!
Who is Participating?
rgn2121Connect With a Mentor Commented:
You could have the Subform bound to SELECT * FROM visits and then on the After_Update event of your date selection, you could filter and requery the subform.

Me.subFormName.Form.Filter = " = #" & variableDateFromForm & "#"
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.