Action Queery parameter

[Joe C]

I am trying to in the queery design view, allow multiple value action queeries.
I would like the user to be able to pick multiple clubs, and in the criteria area have the staement
[What Clubs?]
But for the life of me I can't figure out how to allow the person to pick multiple clubs.

 

[Parra]

What you need to do is create a form, link the form to the query. In the form design view add a combo box that will have the list of clubs. In the query design view, under the club criteria link the combo box.

I know it sounds complicated but its pretty easy.

Or in the query view in the critieria, you can enter the following

[Enter Club]

A pop up box will appear and the person will need to type in the club.

 

[Joe C]

:D
Thanks it worked great.