Johnny Drama
In need of beer...
- Local time
- Yesterday, 17:15
- Joined
- Dec 12, 2008
- Messages
- 211
Hi all:
I've searched and reviewed other posts related to my problem, and I can't seem to figure it out. :banghead:
I've got a form with a subform. In the subform properties a filter is run on load. The filter is Year([Course Date]) = Year(Date()) to filter for all courses taken in the current year.
What I'm trying to do is place a checkbox on the parent form that when checked will remove the filter and requery the subform to show the unfiltered results. I don't think this is difficult, at least for those of you who actually know what you're doing.
Any help would be appreciated. Thanks in advance for your time.
I've searched and reviewed other posts related to my problem, and I can't seem to figure it out. :banghead:
I've got a form with a subform. In the subform properties a filter is run on load. The filter is Year([Course Date]) = Year(Date()) to filter for all courses taken in the current year.
What I'm trying to do is place a checkbox on the parent form that when checked will remove the filter and requery the subform to show the unfiltered results. I don't think this is difficult, at least for those of you who actually know what you're doing.
Any help would be appreciated. Thanks in advance for your time.