Place a control in front of a subform?

[digitalshepard]

Is it possible to place controls on top (in front) of subforms in Access. If so, how is this done?

I have a main form and a subform. I would like to give the illusion that a FEW of the form controls are actually part of the subform, but the rest of the subform controls should appear subordinate to the main form. This is for space efficiency and to create common groupings of elements. The challenge is that "Send to Back" doesn't work with subforms, and the subform is on top of other form controls no matter what I try.

Any good workarounds out there?

 

[RossWindows]

Hmm. The first thing I would have tried is SendToBack on the subform, and BringToFront on the controls you want on top... but it sounds like you tried that already.

Can you put the controls on the subform itself?

 

[digitalshepard]

The first thing I would have tried is SendToBack on the subform, and BringToFront on the controls you want on top... but it sounds like you tried that already.

Correct.

Can you put the controls on the subform itself?

If that were possible it would solve this challenge. However, the fields for the controls are linked to a table different than that of the subform, therefore that doesn't work either.

The reason I would like to place controls in the form on top of a subform is to provide a logical grouping of controls and save space. Not all controls inside the subform will always be visable, therefore there can be blank areas on the form. Be able to make other controls from the form visable on top of the subform would fill the space and be logically placed.

 

[ChrisO]

You should be able to put the controls you want higher in the Z order on another subform and bring that subform to the front.

Chris.

 

[smig]

From my experience you can't.
Try doing what ChrisO suggested or think of new design

 

[Simon_MT]

I'm nor sure of precisely what you are trying to achieve but would the thing be Controls on the SubForm that are set to the relevant Parent Control. Admittedly this might no give the same appeareance if in datasheet mode but you could use Continuous mode and emulate the characteristics of the the Parent form on the Subform.

Simon

 

[digitalshepard]

I think I'll give ChrisO's idea a shot.