Dialog Box - Drop down list

[Debra]

Hi,
I have reports set-up which run from queries- the user is asked to enter the
month which in turn pulls all training records for the month entered. Is it
possible to have the months appear as a drop down in the dialog bos, rather
than the user having to type these in?

Thanks!

 

[Ron2006]

As such, you cannnot do this. However most people desiring to do this
are other equivalent things, simply create their own form that is
called when the user wants the report or needs to run the query,

This allows you to validate information, and/or cancel the operation,
etc.

1) Create the form with the desired entry boxes.
2) modify the query/report to use this new form's fields as the
criteria,
3) place an execute (and/or cancel) button on the form and call the
query/report in the onclick event of the button.
4) optional - close the form as part of the button logic.

Ron

 

[John Spencer]

Check out this article for a detailed discussion.
http://www.fontstuff.com/access/acctut08.htm

Or check out this from MS
http://office.microsoft.com/en-us/access/HA011730581033.aspx

Or for another example
http://allenbrowne.com/ser-62.html


A brief quote from a John Vinson (Access MVP) posting.

You'll need to create a small unbound Form (let's call it frmCriteria) with
a Combo Box control (cboCrit) on it. Use the combo box wizard to select the
table for the selections, and be
sure that the bound field of the combo is the value you want to use as a
criterion. Save this form.

Now use

=[Forms]![frmCriteria]![cboCrit]

as the criterion in your Query.

It's convenient to base a second Form or Report on the resulting query to
display the results; if you put a button on frmCriteria to launch that form
or report, the user can enter the criterion and view the results in one
simple operation!

Quoting John Vinson

Keywords: Parameter Queries, cascading comboboxes

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..