filter report by control name and then by control content

[mvital]

Hi All,

I am using Access 2003. I am using a filter form that allows the user to filter a report in print preview based on certain criteria chosen by the user. It works great. I've been requested to add another filter option. The client wants to be able to choose the controls (fields/columns)he wants to search data for. For example, Date, Investigation, Result etc. so he could filter for one column or all the columns. Is this possible? I am not a programmer. Would I use a visible or invisible, enable or disable. I think I know how I would do it, but again don't know how to start the code.

Any help or examples would be very much appreciated!

 

[wshs]

im not sure if im fully understanding what you want but why don't you create a search form which users can use to filter what they want?

 

[mvital]

I do have a search form (filter form), but I want to be able to display one, two, or all of the controls. Think about a database or spreadsheet. You are able to select via a query the fields you want to specify criteria for. Similarly, I want to be able to choose what fields I want to filter by and then specify the criteria for each, but via my search form (filter form) in a report print preview.

I hope this is clearer. Thanks for responding.

 

[PHV]

Have a look here:

http://download.microsoft.com/download/access2000/Sample/1.0/WIN98Me/EN-US/Qbf2k.exe

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886