Check out this article for a detailed discussion.
http://www.fontstuff.com/access/acctut08.htm
(Warning the above URL may no longer be valid)
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!
End Quoting John Vinson
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
Markitos said:
Is their anyway to have access present a drop down menu box where I can
select which staff name for example. Thanks
Maurice said:
Mark,
I guess what you are looking for is a parameter query.
In the field you want the user to be asked about place the following:
[which staff]
This is the plain variant.
run the query and you will see a inputbox asking you to type in the
parameter which will return the records based on this parameter.
hth
--
Maurice Ausum
Markitos said:
Hello, I need some help.
I have a query called "Client Services" and I am trying to have access
ask
me for which staff to pull records from. Any ideas on how this would
look.
Thanks-
Mark
