Allow users a text area to enter comma separated values as parameters

[tagteam]

I would like to give users a text box where they can create a comma separated list of car numbers that will then be used as the parameter of a query.



For example: user enters 1,3,55,7789,334

And those 5 values get used as the parameter of a query and it returns results for only those 5 cars.

[June7]

Don't think will work with dynamic parameter in a query object.

Review: http://allenbrowne.com/ser-50.html

[tagteam]

Too many cars to do a multi select. There are over 4,000. What are some other options to allow a user to type in a list of 5 or 6 car numbers to search by?

[ItsMe]

It could be done with VBA. I don't think there is a built in array function but I would start there. I am trying to recall what options there are for building an array. Anyway, with that you could add where criteria to a form's RecordSource or a Query Object

[June7]

Textbox seems to work instead of combobox to set form/report filter property with IN operator. It does work in my quick test. No array needed.

Or review: https://social.msdn.microsoft.com/Fo...orum=accessdev

Or maybe use QueryDefs to modify query object

Or maybe programmatically set form or report RecordSource property