Text Box Queries w/out the dialog box prompt, is this possible?

[jmantonbt]

I find the dialog box prompts to be annoying when I run queries, is there a way I can run a query just by entering in the data into the text boxes and having the results return on the form and not a table???

 

[ajdesalvo]

Use the Setwarnings command to suppress the messaging.

For example;

DoCmd.SetWarnings False
Docmd.OpenQuery "YourQuery"
DoCmd.SetWarnings True

I am not sure what you mean by seeing the results in a form and not a table. Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[MattThat]

I follow what is meant.

It would be darn usefull to be able to call a query pass some variables to it have the answers displayed on a custom form... although the query could be displayed on a form but the search would need to display the message or get a value before the form was displayed.

It would be nice to silently pass a var to the Query... Help any?

-Matt