How do I prompt users for a list (not a range) In Access

[Guest]

Hi there.

I've written a generic query in Access that I'd like to prompt users for a
list of values.

I've been reading th following training course, but it only tells me how to
prompt for a single value or a range.
http://office.microsoft.com/trainin...ID=RP010970001033&CTT=6&Origin=RC010969991033

I've tried using the following sql and Access-style [user prompt] in
combination, but it hasn't worked
In ([enter a list])
and typed "1234", "2341"

Any ideas?

It's worth pointing out that I'm searching on a field that has numbers that
are stored as text (don't ask why - it's not my base data!), so i'm in the
habit of using quotes around the numbers so that access doesn't try to guess
that they're numbers - if you see what i mean

Thanks

 

[Allen Browne]

You cannot enter an unspecified list of paramters like this using the
parameter dialog.

You could build the WHERE clause of the query dynamically, as described
here:
Use a multi-select list box to filter a report
at:
http://allenbrowne.com/ser-50.html

While the article is describing how to apply that to OpenReport, it could
also be used as the Filter for a form, or as the WHERE clause of a complete
SQL statement.