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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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)
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
mx
ASKER
I've requested that this question be deleted for the following reason:
Question was answered (sort of), points were awarded!
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...?
Not that I know of, you are just requesting the the Q be deleted...?
See my post before this one
ASKER
Not what I wanted to hear, but it's MS-Access!