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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Prevent Parameter Boxes coming up    
 
   
Triumphman
post Nov 3 2005, 06:39 AM
Post #1

New Member
Posts: 1
Guys,

I have a problem with accessing a report in Access!

The problem is this: I have a user form with some combo boxes where the user can make a selection and the selection is passed to an SQLWhere function that then executes the Report to display the report. The report works with the combo box, but it only works after I have filled in a Parameter Box that pops up after the user has made a selection from the combo box.

Is there away that stops the parameter box from popping up on the screen?? That is to say that the user choice gets passed directly to the report!!!

Regards
Go to the top of the page
 
+
argeedblu
post Nov 3 2005, 06:53 AM
Post #2

UA Forum + Wiki Administrator
Posts: 11,953
From: Sudbury, Ontario, Canada
Welcome to Utter Access Discussion Forums!!

The basic technique for using form control values as criteria in parameter queries is illustrate here . The form with the combobox must be open when the query starts. I generally use a button on the form to trigger the report.

Glenn
Go to the top of the page
 
+
« Next Oldest · Access Reports · 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: 22nd May 2013 - 03:43 PM