Report based on Query by Form User Interface Assistance?

[scs]

I have created a query that uses criteria from 2 text boxes and 1 combo box
located on a criteria form. I've added a commnad button on the form to run
the query and then open the report in preview (using a macro). Everything
is working fine. I'm looking for some guidance on how to make it look more
professional (even though it is not).

It would be nice if the user never saw the query being run. If the user
maximizes the report and then closes it the query remains maximized. I have
created a macro called restore and set it to run on the forms close event.
It doesn't seem to work. Querry is still maximized after the form is
closed.

Any suggestions will be greatly appreciated. I'd love to button this last
thing up and call it a weekend.

Thanks for all the help.
Steve

 

[Duane Hookom]

There is generally never a need to open the query. Remove any code that
opens the query and see what happens.

 

[scs]

Wonder why I keep trying to make things harder than they need to be? Thanks
much! Have a good night.