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    
post Aug 10 2003, 08:17 AM

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)
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