Multiple parameter prompt in a query (InParam)

[Marchelle]

In earlier versions (2000) of Access I was able to create an InParam module
and have the query prompt me for multiple values separated by a ",". 2003 or
2007 does not allow me to. Anyone have any ideas?

 

[Ryan]

I just tested this and it worked great for me. In your query, on the field
you want to parameters on add this to the criteria.

In([your message to the user to])

The In([]) will ask the user for the parameter values, and whatever you type
between the [] will be what they are prompted with. With the In, you can add
multiple values seperated by a comma. So if your users added 1,2,3 then all
records with 1 2 or 3 would show up. No need for the " all they need to do
is use the ,

 

[Marchelle]

Well, that didn't go well...
The prompt never appeared and the query returned all.

I just tested this and it worked great for me. In your query, on the field
you want to parameters on add this to the criteria.

In([your message to the user to])

The In([]) will ask the user for the parameter values, and whatever you type
between the [] will be what they are prompted with. With the In, you can add
multiple values seperated by a comma. So if your users added 1,2,3 then all
records with 1 2 or 3 would show up. No need for the " all they need to do
is use the ,


--
Please remember to mark this post as answered if this solves your problem.

In earlier versions (2000) of Access I was able to create an InParam module
and have the query prompt me for multiple values separated by a ",". 2003 or
2007 does not allow me to. Anyone have any ideas?