Subfrom issue using Calendar control

[Sam Summers]

I am trying to use an unbound subform based on a query to display only records for a specific date. The query works fine on its own, but the subform returns a blank.
I am using the Calendar control on the same form for the user to select the date they wish to view. This in turn inserts the selected date from the calendar into a textbox on the main form and the query that the subform is based on reads this and opens the corresponding records.

Problem, its not working.

Thank you in advance if you can help me throw some light on this one.

 

[AN60]

My suggestion;
1.Make one unbound form
2.Place two txt boxes on the form. Maybe you could name them something simple like Start & end.
3.Add calendar controls (Buttons) on the form or reference a calendar from the txt boxes double click event so double clicking the boxes gets the calendar to insert the date(s).
4. Go to your query & in your date field reference the date fields (start & end) on your unbound form
5.Add a button on the form to open your report which is based on the same query as above.
For this to be of use I have assumed your "corresponding records" is a report.
I hope this is what you need. Good luck.
PS. There are plenty of examples on this forum which will show you what you need.