help with query input please

[f_disk]

I have a query that has the following script.

[Enter oner1, such as m20] Or [Enter oner2, such as m20] Or [Enter oner3, such as m20] Or [Enter oner4, such as m20]

Basically, it pops up one window after another as you input your info.'
Then after the four pop ups it will go and retrieve the needed information.
It works great for me....

Is there a way for me to take this query script and if I leave one pop up blank it would just go and find what I put in without having to press
"enter" for the additional inputs that I did not want...
It's a pain when I increase this to 10 pop ups and one need one...

Example :

Lets say I only want to input two and then go
find the information.
right now I have to continue closing the pop ups until
I have cycled through all four and then it will go.
I want to eliminate the additional ones.

I'm not a genius at this so please make it as easy as you
can if you have any ideas....

thx

 

[grnzbra]

You could create an input form to collect the criteria. I had a database with many reports run on similar parameter queries and people were getting annoyed with a stead stream of requests for individual inputs. I created a form that had the entries in the text boxes transferred to global variables. There were a set of public queries that looked at the corresponding variable and if there was something in it, the function was set to that variable. If the variable was empty, the function was set to "*".

The query criteria were then set to

Like Function()

 

[f_disk]

thank you

I ended up using your idea and then some.
I now have a text box where I can enter one
and find the results and I have a list box that
will allow me to select any amount from the list
and then do a search and pull up the results.

thanks again for your help !

 

[grnzbra]

I ended up using your idea and then some.
I now have a text box where I can enter one
and find the results and I have a list box that
will allow me to select any amount from the list
and then do a search and pull up the results.

thanks again for your help !

Glad to hear things worked out. I just noticed an error in my statement. It should be:

There were a set of public functions that looked at the corresponding variable and if there was something in it, the function was set to that variable. If the variable was empty, the function was set to "*".