How to call inputbox for query criteria?

[bILLyYaNk]

Hello,
I have an Access 97 database where the criteria for a bunch of queries has to be changed when the user runs it. It would be nice if when the macro runs an input box would pop up asking for the criteria for the running query. That way the use won't forget to change the query's criteria {and I know they will). I searched and couldn't find the code anywhere to do this.
Thanks!
-Scott

 

[SiJP]

In the criteria field type: "[Enter your dogs name here]" (without hte quotes, but with the square brackets...

------------------------
Hit any User to continue

 

[Darrylles]

Hi,

In the query editor, enter the following in the 'Criteria' row of the field column(s) that you want the user to specify:

[Please enter criteria:]
or
[Please enter date:]
or
[Please enter £ value:]

The square brackets signify that you want the query to prompt the user for criteria for this field with the text enclosed within the square brackets.

ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk

 

[Darrylles]

Whoops - entered mine just too late -

Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk