Form on form

[Bobp3114]

I have been asked to change present forms so that there is a"Background" form with no connection to any table and that only contains a few Command buttons. Then showing always, three smaller forms, each derived from it's own query and always placed on the background form in the same position. Each of these three forms to act independently of each other.
I can open each in sequence and make the three popup but this seems sloppy
Any ideas appreciated
Bob

 

[bbfromgb]

have a look at Daniel Pinault's excellent paper on Subclassing Forms (w_w_w.devhut.net/microsoft-access-form-subclassing-101/) as an idea. He also provided a youtube video on that topic

Greetings
Bernd

 

[MarkK]

Seems sloppy how? Like, since we can't see--and you haven't described--the specific sloppiness in question, how do we suggest useful de-slopification ideas?
Describe what "sloppy" means to you in greater detail.

 

[Edgar_]

and always placed on the background form in the same position

Does that mean overlap? or maybe one next to the other?

What is sloppy? the popup version? the side by side version? the overlapping version?

What is it supposed to solve?

Why 3 forms? Why exactly 3 and not more?

 

[CJ_London]

sounds like the background form just needs the buttons and 3 subforms

 

[Jason Lee Hayes]

This sounds like a classic case of needing a clean, modular UI in Access that mimics a dashboard-style layout. The goal is to have a persistent "Background" form acting as a container, with three independent subforms that behave like widgets, each driven by its own query which is what you are doing... Nothing sloppy about that!

If you're targeting different screen resolutions or Access window sizes, consider using Anchoring in the subform controls to keep them in place relative to the background form edges.

 

[Ken Sheridan]

I have been asked to change present forms so that there is a"Background" form with no connection to any table and that only contains a few Command buttons. Then showing always, three smaller forms, each derived from it's own query and always placed on the background form in the same position. Each of these three forms to act independently of each other.

As others have said, doesn’t this simply require an unbound parent form in which are placed three bound subforms? The image below is of a simple example from one of my online demo files. In this case the parent from is bound, and the subforms' RecordSource properties are three different queries on the same table, but those factors are by the bye. The parent form could equally well be unbound and the subform's based on different tables.

 

[mike60smart]

I have been asked to change present forms so that there is a"Background" form with no connection to any table and that only contains a few Command buttons. Then showing always, three smaller forms, each derived from it's own query and always placed on the background form in the same position. Each of these three forms to act independently of each other.
I can open each in sequence and make the three popup but this seems sloppy
Any ideas appreciated
Bob

Upload the database so we can see what you mean.

 

[MajP]

then showing always, three smaller forms, each derived from it's own query and always placed on the background form in the same position.

By in the same position does that mean all three forms appear on the main form in their own position or you display one of the three forms in the same (one position).
If it is the former do as in post #7. If the Latter it is a matter of making on single subform control and then the buttons change the Source Object of the subform control. So each button makes a different subform appear. However it may be simpler than that. You just change the rowsource of the subform.

 

[LarryE]

Just create an unbound MainForm and add each of the other forms as subforms. You can auto-center it and use that form to auto-open when the project is opened. I use this technique especially when there are a lot of continuous forms used in the project that don't allow subforms to be used. You still have access to the forms when the project opens without having to always click a button. You can position and size the subforms as you wish and they always stay in the same place on your screen. You can also make forms visible and not visible as needed. I do use command buttons for that placed on the MainForm anywhere I wish.

 

[Pat Hartman]

I think I counted 4 or 5 people telling you to add the three "popup" forms as subforms on the unbound form. They will stay where you positioned them and not move around. Popups are the wrong solution, in case that wasn't clear.