Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / August 2006

Tip: Looking for answers? Try searching our database.

Using an Access form to enter parameters for a Query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jborron - 10 Aug 2006 21:28 GMT
I have a query with 4 parameters that feed a report.  I have made a form with
combo boxes with the criteria for each of the parameters and have it set to
open when the report is opened.  When the criteria is set for the parameters
and the enter button is hit the criteria doesn't feed the query it will still
pop up 4 criteria boxes.  I have the following formula entered in the query
field criteria
[Forms]![Form Name]![Combo Box Name On Form].  this is the exact same format
as that the Office Help page showed.  Can someone tell me what I'm doing
wrong or missing.  I even down loaded the example Access file and made my own
query, report and form that mirrored the ones that worked and I still
couldn't get this work.
pietlinden@hotmail.com - 10 Aug 2006 21:42 GMT
remove the parameters from the query.
Create a filter (valid SQL Where clause) and pass that in the Open
event of the report.  Makes the report MUCH more flexible.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.