manipulating multiple subforms

3

303factory

Registered User.

Local time

Today, 04:50

Joined

Oct 10, 2008

Messages

136

• Dec 3, 2009

• #1

Hi all

My applications main screen has about 15 subforms layered ontop of each other (all identical size) Depending on which dataset the user is looking at only one will be visible.

This has worked fine for many years but its a real pain to do any design changes, if I want to widen the forms or change their position slightly i have to carefully move each subform and layer them perfectly ontop of each other so there is no bits sticking out etc

Any way I can combine these so there is only one thing to resize/move?

Regards

303

 

DCrake

Remembered

Local time

Today, 04:50

Joined

Jun 8, 2005

Messages

8,623

• Dec 3, 2009

• #2

Take a look of how I do it:

On your main form you add one subform and give it a name, say DisplayPanel
Then when you click on a menu option or a command button code the following

Forms("FrmMain")("DisplayPanel").SourceObject = "SubFormName"

This will refresh the subform source so there is no need to have muliple subforms on one main form.


I have attached a sample mdb to show what I mean.
David

 

Attachments

• MainFormSubForm.mdb

  116 KB · Views: 499

Last edited: Dec 3, 2009

S

smig

Registered User.

Local time

Today, 06:50

Joined

Nov 25, 2009

Messages

2,209

• Dec 3, 2009

• #3

what DCrake suggested will also make your application thiner as only one subform will be loaded at a time (I guess now you hide/unhide them).
but it might take a bit longer to change the subforms, but unless they are very very heavy it shouldn't be noticeable at all.

 

3

303factory

Registered User.

Local time

Today, 04:50

Joined

Oct 10, 2008

Messages

136

• Dec 3, 2009

• #4

wow thats so much faster and more efficient.. thanks guys

 

3

303factory

Registered User.

Local time

Today, 04:50

Joined

Oct 10, 2008

Messages

136

• Dec 3, 2009

• #5

um how do I reference controls on the subform now?

'Me.subfrmname.button' is no longer working as the subform is no longer a subsection of the parent form. Also
Me.displayPanel.button wont work and Me.displayPanel.subfrmName isnt working either..

 

DCrake

Remembered

Local time

Today, 04:50

Joined

Jun 8, 2005

Messages

8,623

• Dec 3, 2009

• #6

I intially had this problem and this is what I did to resolve it

Forms!FrmMain.Form!DisplayPanel.Form!SubFormControlName = "Whatever you want it to be"


David

 

3

303factory

Registered User.

Local time

Today, 04:50

Joined

Oct 10, 2008

Messages

136

• Dec 3, 2009

• #7

awesome.. that did the trick nice one.

where would i be without this forum..

 

3

303factory

Registered User.

Local time

Today, 04:50

Joined

Oct 10, 2008

Messages

136

• Dec 3, 2009

• #8

here's a slightly trickier one

I used to switch between datasheet and form view with the following code

DoCmd.RunCommand acCmdSubformDatasheetView
DoCmd.RunCommand acCmdSubformFormView

However 'the command or action 'SubformDatasheetView' is not available now.. I must confess I dont really understand the DoCmd function very well so have no idea what's changed to not allow this to wok

 

DCrake

Remembered

Local time

Today, 04:50

Joined

Jun 8, 2005

Messages

8,623

• Dec 4, 2009

• #9

Is it the subform that you are toggling?

David

 

3

303factory

Registered User.

Local time

Today, 04:50

Joined

Oct 10, 2008

Messages

136

• Dec 4, 2009

• #10

DCrake said:

Is it the subform that you are toggling?

David

Click to expand...

yes it is .