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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Using a form to control parameter queries    
 
   
argeedblu
post Aug 10 2003, 08:17 AM
Post#1


Remembered
Posts: 14,079
Joined: 26-September 02
From: Sudbury, Ontario, Canada


Parameter queries provide a means to make queries more flexible by allowing criteria to be specified when the query is run (or a report or form based on the parameter query is run.)
nfortunately, when the query requires multiple criteria, Access displays message boxes requesting each criteria, one at a time, something most users would find very tedious, not to mention amateurish.
The attached database demonstrates how to use a form to collect the criteria and set them up in the parameter query and then generate a form that uses the query as its data source. This methodology enables you to use comboboxes (as in the demo) to display valid choices (something the standard parameter query does not make possible)
Glenn
Attached File(s)
Attached File  cboquery.zip ( 120.5K )Number of downloads: 1354
 
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    4th July 2020 - 07:25 AM