UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> help using radio buttons    
 
   
JDrake
post Mar 16 2005, 11:40 AM
Post #1

UtterAccess Addict
Posts: 218
Hi,

I have 3 radio buttons on form "report options" in which I would like to select what query generates my report; My problem is I don't know how to set this up. Any help provided would be GREATLY appreciated..

Thanks,
Jd
Go to the top of the page
 
+
Jack Cowley
post Mar 16 2005, 12:07 PM
Post #2

Retired Moderator
Posts: 37,716
From: The San Francisco Bay Area
In the On Format event of the report:

Select Case [Forms]![NameOfYourForm]![NameOfOptionGroup]
Case 1
Me.RecordSource = "QueryName"
Case 2
Me.RecordSource = "QueryName"
Case 3
Me.RecordSource = "QueryName"
End Select

The form with the option group must remain open AND this code is pure aircode and has NOT been tested...

hth,
Jack
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 05:47 PM