collecting values for use in a query...

[thepope77]

Hi:

I have a query that builds a table for use in a report and I need to be able to key multiple entries as criteria. These are not always the same number of entries. How do I capture these values for use in this query? I was thinking along the lines of an input box that has custom buttons that the user can select to tell the query when they are finished keying in values. Then the query uses the values when it runs.

Could someone please let me know if I am way off base or somewhat near the stadium? Any suggestions would be most welcome.

Thanks so much.

 

[kphu]

Hi,

Since you've gotten no response, here's my thought.

You can create an array to save the data. The first input box will ask for a number how many criteria's the user will enter in.

This number will then be set in an array to store the data.

Hope that will get you started.