Run Query Based On Radio Button

[rocky143ch]

hello friends,

I am new to this forum. I am posting an example database to solve my problem. I had a database with '4' fields and a query which display '4' fields. I have designed a form with four radio buttons and assigned the name as table field name.

Now my Question is The Query output should display the fields based on my selection i.e., which radiobutton I tick only that fields should display in my query. How to do it...I am attaching the database kindly complete it and mail to rocky143ch@gmail.com




Thanking you Friends.

[June7]

Would have to save 4 different query objects and have code open appropriate one. Or code would have to modify one query object using QueryDefs collections.

Why do you need to do this?

[rocky143ch]

I cant understand what you said. My theme is we had an option called 'show' when we are in query design mode( to show or hide the field in a query). Is there any way to check and uncheck that 'show' property of a query using 'checkbox' or 'radiobutton' by placing the 'checkbox' or 'radiobutton' on form without opening the query in designmode

[June7]

That is modifying the query with VBA code that manipulates QueryDefs collection. A bit advanced coding concept for new user.

Otherwise, bind form to the table or query and use code to:

1. hide controls that are bound to the fields - form in Single view

2. hide columns - form in Datasheet view as a subform, the main form would have the radio buttons


Still, why do you need this? What are you really trying to accomplish?