Help with expressions and parameters access 2003

[Guest]

I am setting up an access 2003 database at work. I need to set up one of my
queries with 100 parameters
EX: ([product id 1] Or [product id2] Or ..........up to [product id 100]
However with this expression the user must enter 100 values or press enter
the remaining amount of parameters. I understand I can create 10 different
queries each with a different amount of parameters in each but I feel this
would be confusing to users. I would like Access to ask "are there any more
product ids to enter". Can I do this? If so How

Thank-You
testtech2522

 

[Douglas J Steele]

Could you possibly present a form with all of the options in a multi-select
list box, let them choose as many as they like from it, and use that with
your query?

http://www.mvps.org/access/forms/frm0007.htm at "The Access Web" shows the
code you'd need to use.

 

[Larry Daugherty]

You already have a thread going on the same issue in this newsgroup.