Multiple parameters

[tipperjoe]

I'm looking for a way to allow the end users to enter multiple criteria in a parameter in a query. In theory I thought this critieria would work, but instead it returns nothing.
Criteria value:
In ([Enter Item#(example: "D05494","IM5506")])
If I hard code the item numbers like this: In ("D05494","IM5506"). It work fine. I want the end user to make multiple selections without going into the design view of the query or have them enter the criteria in a separate table. Can anyone help ? It would be greatly appreciated

 

[SydneyGeek]

Change the criteria line to:
In "(" & [Enter Item#(example: "D05494","IM5506")] & ")"

Denis

 

[tipperjoe]

Hi Denis
Thanks for the quick reply, I copied your solution straight to access and got the message "The In operator you entered requires parentheses"

Joe

 

[Rupert Bennett]

Here is a video that shows how to do this:
http://www.datapigtechnologies.com/flashfiles/multiparameterbox.html

Rupert