Search form to select specific fields from a query

[ManuelLavesa]

Ideally what I am trying to accomplish is the following: I have a query that shows all the product information. ProductName, Description, Price, Quantity in stock, Supplier etc... Now I am making a search form that contains unbound controls for each field which are then used as criteria in the query. So now if I select a product it displays all the information for that product. But now I want to filter that result. For example if I am only interested in displaying the product name and Price and hide all the other fields because I am making a Price List. Or I just want to see the Supplier and their products and Hide all the other fields. I know that I could make different queries for each situation, but then I windup with a 100 queries... So in conclusion what I want is to be able to show and hide the fields from the query depending on what the user wants to find. Is this possible, and if so how do I do it... Thank you for your help

[orange]

Have you analyzed your requirements? I think you may have some different queries but not nearly 100.
Perhaps you could tell us more about your database, the tables and relationships involved.

Sounds like you could have a form with some buttons to run queries/reports based on some user selected choices.

[June7]

Display of fields in query cannot be dynamic - at least not without VBA code that modifies QueryDefs. Strongly advise against this as this is programmatic db design modification.

Build reports.

[ManuelLavesa]

Thank you both for your suggestions. June7 you are right it requires VBA code. I found the answer and that is making check boxes and then have the VBA write the SQL statement taking in consideration the fields that the user has selected before firing the Query. In that way the user is making the queries without knowing.