How to make certain option buttons run certain queries. 2

[KaayJaay]

Now lets say i have 4 queries, i want the option buttons in the group to basically pick which query is to be ran, then i have two date range text boxes. The plan is to make it so that depending on which query is ran and the date range entered, a reulst is returned, but im not sure how to make certain option buttons run a certain query. Any suggestions?

KaayJaay

 

[KenReay]

Hi

Have a button on the form to run the query, in the onclick event of that button

Select case opgMyOptionGroup
Case 1
MyQueryName = "Option1Query"
Case 2
... you get the idea ?
End Select
DoCmd.OpenQuery MyQueryCommand

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[daveod]

Thanks Ken

As usual (Tek-Tips and yourself) what I need, when I need it. Star coming.

Dave