allow multiple values in unbound field for query parameters

[tagteam]

I am trying to find a way to allow the user to enter multiple numbers in an unbound box that I will pass to a query as parameters. I already have it set up to pas the parameters from the form but if i try to do more than one number it doesnt work.
I have tried
1306 or 1307 or 1308
1306, 1307, 1308
"1306 or 1307 or 1308"

I was reading somewhere that when the value is picked up from the form it is not like you are typing it right in the criteria box of the query.

So are there any other options here?
Is there a way to enter all the number in a box and then use vba to create an array and then pass that to the query? I am intermediate with access but a beginner with vba.
Thanks

[pbaldy]

It isn't the same as typing in the criteria in design view. Design view is just a user interface to create SQL. When you type that in the design grid, Access understands and converts it to proper SQL. "1306 or 1307 or 1308" would become SQL of:

WHERE FieldName = 1306 or FieldName = 1307 or FieldName = 1308

When you put that in a form control, Access doesn't make the conversion for you. I'm not sure of an easier way, so I suspect you're stuck with VBA to convert the input into proper SQL. The exact solution I would choose would likely depend on the end goal. If it's to open a form/report, I'd create a wherecondition rather than manipulating the query.

[ranman256]

The BEST way I think, let the user enter values into a table (multiple values)...link the table to your query results.