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 visits.date=variableDateFromForm

Thanks in advance!
LVL 1
WavyGravyAsked:
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 = "visits.date = #" & variableDateFromForm & "#"
me.subform.Form.FilterOn=True
Me.subForm.Form.Requery
0
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.