Link to home
Start Free TrialLog in
Avatar of dibrandt
dibrandt

asked on

MS-Access Query

Is it possible to set the field criteria of a  query to display a list to select from, when the query is called?
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dibrandt
dibrandt

ASKER

Thanks,  
Not what I wanted to hear, but it's MS-Access!
Depending on how many options they have, you could alter your prompt.

Instead of

[Please Enter a Value:]

You could have a prompt like:

[Please Enter a valid value: (Option1, Option2, Option3, etc)]

In some older versions of MS Access you could even use ^J (control J) for a new line. So the above could be displayed on two or more lines:

Please Enter a Valid Value:
(Option1, Option2, Option2, etc)

I don't know if this functionality has been retained in the current versions of Access.  You might want to give it a try.
<Is it possible to set the field criteria of a  query to display a list to select from, when the query is called?>
You can use a Multiselect Listbox...
http://access.mvps.org/access/forms/frm0007.htm
(http://access.mvps.org/access/reports/rpt0005.htm)
Right ... of course, that list box in on a form ... the query does not make it popup at runtime ...

mx
I've requested that this question be deleted for the following reason:

Question was answered (sort of), points were awarded!
How did you resolve this problem?
<Question was answered (sort of), points were awarded!>
Not that I know of, you are just requesting the the Q be deleted...?
See my post before this one