Hi there,
In the attached database, I have a form called frm_filter which displays a list of set reports and 6 filter options.
On opening this form all of the filter options are disabled.
I want to try and make this form really smart so I have used a list of report that can definitely be filtered on.
What I need to do now though is on the listbox_afterupdate event, enable the relevant filter options for the report chosen
How can I say in vb the following:
check field names in report and if they match any of the filters
enable those filter options for the user.
This seems complicated but I think it is more my inability to fully explain what I am trying to achieve.
I want the user to be able to filter one report, but that one report can be selected from a variety of reports and thus not all filters can be enabled as not all filter fields are used on each report.
Any advice or help would be greatly appreciated.
Thanks
Kate
In the attached database, I have a form called frm_filter which displays a list of set reports and 6 filter options.
On opening this form all of the filter options are disabled.
I want to try and make this form really smart so I have used a list of report that can definitely be filtered on.
What I need to do now though is on the listbox_afterupdate event, enable the relevant filter options for the report chosen
How can I say in vb the following:
check field names in report and if they match any of the filters
enable those filter options for the user.
This seems complicated but I think it is more my inability to fully explain what I am trying to achieve.
I want the user to be able to filter one report, but that one report can be selected from a variety of reports and thus not all filters can be enabled as not all filter fields are used on each report.
Any advice or help would be greatly appreciated.
Thanks
Kate
