Multi-entry Parameter

[mrabrams2]

Simple query.
Field: CompID

In a query - drop the field to grid.
Criteria line - [Enter a CompID]
Works great when user enters ONE CompID.

What I would like, is for the user to be able to enter 1,2 or 3 CompIDs as the criteria.

How do I do this?

Thanks!
Michael

 

[Pat Hartman]

You will need to create a form with a multi-select list box and write the code to create the query and run it. If you search the archives for multi-select list box, you will find samples of the code you will need.

 

[Rich]

Lookup the InputBox and the In functions

 

[mrabrams2]

Thank you very much

Michael