Report based on Query by Form User Interface Assistance?

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

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

--
Duane Hookom
MS Access MVP
--

"scs" wrote in message
...
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

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

"Duane Hookom" wrote in message
...
There is generally never a need to open the query. Remove any code that
opens the query and see what happens.

--
Duane Hookom
MS Access MVP
--

"scs" wrote in message
...
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