on this form, i have 6 check boxes years from 2007-2003, and ALL years. the
users should be able to check more then one when they are trying to filter on
years. The field just contains year in the main table.
when i click on apply filter whatever year i have checked it should appear
on the subform. Example of the code below. the code i have just lets me
filter one at a time. if i check 2003 and 2004...
dbpatadia
Last Activity: May 24 '06, 02:25 AM
Joined: May 8 '06
Location:
-
Filter
[B]i have a form with three Option groups and one combo box and i am trying to filter it out to the subform that i have on the same form. here is the code, everytime i try to click on Apply Filter. its not working. my filter is not showing on the subform.
Dim strmarket As String
Dim stradvertisers As String
Dim strheading As String
Dim strudac As String
Dim strfilter As String
... -
Access check box and option button to filter
I am having trouble on a form where i am trying to filter out data using check boxs and option buttons. I have added an attach to show how my form looks. Also I want to be able to check more then one check box at a time under Book Year. But its not working for me. Is it better to save a marco behide each check box or have one behide a comand button. what is the best way i would do this so what ever the user check it should pull from the table. ...Last edited by dbpatadia; May 11 '06, 02:04 PM.
No activity results to display