Pop up form stay on top while accessing main form(s)

[JRodko]

I have been googling this issue for about 60 minutes and I'm not having much luck. I suspect it's a unique issue and might not be out there.



I'm trying to have a form, lets call it 'frmSummary' act as a pop-up that can be moved around and will stay on top, but it also allows the user to navigate other forms.

Is this possible? The reason I am doing it is that it is a summary form and I need my users to be able to access other data filled forms so they can reference a number of different data fields.

I believe the number of other data tables they'll have to click through does not make it practical for me to bring up additional sub-forms or use split forms to show data they might need to reference.

I tried to enable the minimize button but when I minimize the form disappears completely and I can't even bring it up from the taskbar. Although if there's a way to do this that would also work.

To attempt explaining it another way: I'd like it to act as a modal form where it stays on top and is move-able, but I need to retain the ability to navigate other forms in the background.

Thank you

[Micron]

AFAIK, not possible. The closest you would come is either tabbed forms, which would put them side by side, or have the other forms pop up modal to see whatever is related to whichever you consider the prime form to be, so the related data can be seen. Why are there so many other tables involved? You can't base the form on a query that joins them and show the related data in one form or a form with a minimal number of subforms? Not saying it's so, but when someone posts that there's too many tables or fields involved, it's usually because of improper normalization.

[JRodko]

I was afraid of that answer, but I kind of expected it.

There's no way to get around the number of different data sets or data types I have to collect unfortunately. I will play with the idea of subforms and tabbing, though I suspect it'll be too hectic.

Thank you for the info!

[Micron]

Just to be clear, that was tabbed forms, not tab controls on forms.

[JRodko]

Subforms on tabs?

[Micron]

No. Go
File > Options > Current Database. Tabbed Documents is under Application Options.
I doubt you will like the view as all forms will take up the entire application window, but it's easy to revert to Overlapping Windows.

[Missinglinq]

I'd like it to act as a modal form where it stays on top and is move-able, but I need to retain the ability to navigate other forms in the background.

Why does it need to be Modal? If it is simply a Popup Form, it will stay on top, be movable, and the other Forms can be used as usual.

My only concern with this approach would be that it would lead to a very cluttered interface.

Linq ;0)>

[Micron]

No. Go
File > Options > Current Database. Tabbed Documents is under Application Options.
I doubt you will like the view as all forms will take up the entire application window, but it's easy to revert to Overlapping Windows.

After reading Missinglinq's post, I think I misunderstood your original post. I thought there were several forms that you wanted to behave like a popup. While you can do that, multiple popups won't behave much different than regular forms. Sorry if I misinterpreted the problem.

[JRodko]

Micron,

Thank you for the idea. It does not seem to change my issue.

I would like for one of my forms to be pop up, and move-able, but for it to stay focused even when I am clicking around in the background. This is so that I can reference other information and quickly come back into my pop up form while still being able to read what I've opened in the background.

Cheers