Form / sub form question in design view

[vgersghost]

Hello:

I have a main form and a large sub form that covers alot of the main form fields. My question is when I'm in design mode, the sub form blocks the fields I need to edit. I've tried setting the sub form "sent to rear" and the fields "sent to front", but this does not seem to solve the problem. So I end up dragging the sub form
off to no-mans land and then place it back. Is there way to say hide the sub form in design view and then unhide it.

Thank you
dmh

 

[ThreeCrow]

Maybe it's just me, But I have got to know.

Why do you want to have the subForm covering the Controls of your MainForm?

 

[vgersghost]

Answer to question

There are actually five sub forms on top of this main form. Two show current collected data in spreadsheet format relating to other data when requested and can update main form or other sub forms. Other sub forms history data and graphs when requested.

This is just one set of forms / sub forms.

Just a lot of data to analyze.


thanks

 

[ThreeCrow]

Got it, sounds like a dandy multiFunction Form.

Instead of covering these controls with the subForms.

Why not place them elsewhere on the mainForm, if you do not wish to see them set the visible property to No.

If these Controls are for selection uses for the subForms, maybe create another subForm.

 

[vgersghost]

The problem is in design view

Thank you for your answer, but the sub forms all have controls to be hidden and
un-hidden from the main form. What I need is a way to hide them in design mode, without having them to be drag around the form to get to the fields below. I'm still in the process of designing all the forms and sub-forms that why I need a solution for design mode.

thx

 

[ThreeCrow]

I understand the problem, I also understand the way that you want the Form to Function for the end user.

In Design View you are limited, to Design only. And in Design View of a mainForm or subForm(s) it can be at times really cluttered, and unreasonable to work with. When Designing a Form you'll be going through trails and errors until you have the Form working the way that you want it to. With my suggestion of another subForm, this would have those Controls that you now have covered by the subForms, on it. This way you will have access to them to work with, and change as needed.

 

[vgersghost]

Okay, now I understand!

I wasn't thinking about adding those fields to an additional sub form and then working with that as a separate sub-form. I could have that sub-form just open with the main form and continue to use the controls for the others. Just got in a mindset I needed those fields on the main form. I mean I already work with the other sub-forms the same way. Thanks for clearing up my mind.

The only problem I can think of, the sub-form would be reading from the same table / query as the main form. Not sure how the data would update. I'll work on it.

thx

 

[ThreeCrow]

We all get into those mindsets, the forum is to help us get out of that thread of thought.

Happy to have been there for you.