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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Option group to determine which report to call?    
 
   
kmart320
post Dec 6 2004, 05:45 PM
Post #1

New Member
Posts: 19
From: TX - USA
I want to utilize an option group on a form to call a report based on the option selected. Basically select option and click a button to generate the report. How do I get the button to recognize which option is selected in order to pull the report?

Thanks!
kmart320
Go to the top of the page
 
+
HunterOfTheShado...
post Dec 6 2004, 06:12 PM
Post #2

UtterAccess Veteran
Posts: 367
From: South TX
Use VBA. If you are using a cbo box for your options, then in the SQL or whatever you base your report on, reference the box ( eg. in qry -> fname in qry design view make it "where" and criteria is forms!frmname!fnametxtbox.value).

You can also set the fname = to fnametxtbox on the "run report" cmd button on the On click event of the cmd button.

HTH

-Hunter
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: 23rd May 2013 - 06:46 PM