DavidW said:
Not all of my forms are popup. There are certain forms that I am using as
popups(small sized). I dont need them to be as large as the screen. Is there
a way to get a small-sized(fixed) form with out setting the property to
popup.
Thanks for responding!
Well, if you make those forms model, then they will stay on top of
*previous* forms, but the FOCUS will ALSO have to remain on those forms.
However, model forms DO LET you launch reports, and the report will appear
on top.
I have tons of forms that I use to launch reports, and the reports ALL have
a
docmd.Maximze
In the reports open event. however, the forms that launch the report are
NEVER maximised, and those forms NEVER take on the maxed status of the
forms, or reports that follow. You can make forms keep their setting (ie:
NOT MAX, or NOT MIN) by simply turning off the max/min buttons setting (this
makes sense, since if you can't max, or min a form, then the form can't be
maxed, or mined!).
With popup forms, they will stay on top of the report (and they are supposed
to by design). So, I am not really sure of a solution here, but to dump the
use of popup forms seems a possible solution
I always provide my users with a nice screen that launches the reports.
Those reports always max to full screen, and the users really like this.
When they close the report after viewing, they are return to a nice little
form, and that form is NOT maixied, nor does it take on the settings of the
report (since as mentioned, I remove the min/max buttons from he form).
Here is some screen shots of those reports prompts I use.
http://www.attcanada.net/~kallal.msn/ridesrpt/ridesrpt.html
So, if this is ONLY a problem of max/min stuff, then popup forms are not
needed at all here. It is still not clear if you actually do need the popup
forms.