Close 'report filter' form

[STiruchi]

I have a pop-up form that opens in front of the report and is used to
filter report entries. However, when I Close the form from the command
button, the report closes too. Is there any way of just closing the
form and keep the report open?

Thanks in advance for any advise.

ST

 

[Jeff Boyce]

It sounds like the problem may be that the form is a "pop-up" form (modal).

Anyway, if the form serves to "filter report entries", wouldn't closing it
mean the report has nothing to go on?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[STiruchi]

In the modal form I have 3 command buttons and one of them is the
close command (filter, clear are the other two). Is it not possible to
write a code so that only the form is closed (either by using the
close command or x at the top) and the report stays open.

Thanks in advance for any advise.

ST

 

[Jeff Boyce]

I may not be following your explanation.

If you use a form to "gather" selection criterion for your report, I would
think that closing the form means the report loses the selection criterion.

Rather than making the form modal, how about if you just open it? Then,
when you click the <Report> button, you can hide (not close) the form and
bring up the report (in Print Preview mode, I assume). That way, you could
also add code to the Report's OnClose event to unhide the form.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP