Filtering Subform

[bitech]

This is so frustrating because I know it's easy. I have the calendar Active Control on a form. When the user selects a date I want the subform to jump to that date and reveal the events for that date.

To test whether or not Access could distinguish the date from the calendar, I made a message box so it would tell me the date. IT WORKS! Now I've tried applying filter, even changing the subform's recordsource but nothing works. please help

 

[mac318]

Using the recordsource is the proper approach. Try this format for your filter:

Forms!FormName!SubFormName.Recordsource = "Select ..."

I use it successfully to build an SQL statement which populates a subform at run time based on the value of a field. Oh, I usually place the field in variable and use the variable in the SQL statement.

mac