Using the Calendar Control to Filer Records

E

Ed Crawford

I have MSCAL.Calendar.7 object a main form that I would like to use to filter
records on a subform. The query that drives data on the subform has date
field andthe criteria defined as:

[Forms]![frmTMSparent]![Calendar0]

When the main form is open and I manually enter Shift +F9 the form behaves
exactly as I want. The records on the subform filter to only show those that
match the date on the calendar object. Change the date on the calendar
object, enter Shift +F9 and information is again updated fine.

I would just like to not manually enter Shift+F9 to update the records on
the subform.

Please be pretty specific with any code suggestions, if that's what it
takes, as a programmer I'm not.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TextBox on the main form to limit SubForm 2
Problem with form--subform 5
Simplify Outlook Calendar 0
QBF & Query Malfunction 0
Mail Merge skipping records/sending one at a time 0
Automatically populate NEW RECORDS in Subform(for field not Linked 13
Subform - Access 2003 2
subform filter 7

Top