Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to edit subforms placed on top of one another

Status
Not open for further replies.

ksbigfoot

Programmer
Apr 15, 2002
856
CA
I am using MS Access 2003.
I have a form that contains 4 subforms.
2 of my subforms are placed exactly on top of one another and through VBA code, I make one visible and the other invisible.
Right now I have to drag my subform off the form below it, to be able to work on the subform underneath it. Is there an easy way to make the subform on top "Send to back". I highlight the container the subform is in and go to the menu and click "Format", then select "Send to back" and nothing happens. Is there another way to do this without dragging the subform off the subform beneath it.
Thanks
 
I stated above: "I highlight the container the subform is in and go to the menu and click "Format", then select "Send to back" and nothing happens."

That is still true. But since I am in design mode, if I View the form (see all the data), and then go back into design view, the form did go behind and I see the form I need to see.

Who would of thunked it!!

ksbigfoot
 
In tha past I have played around with setting the positions and sizes of forms in the main on open event. So you can manipulate them during design time, and on open they go to where there coordinates have been set. It took me a lot of playing around, someone might come in and give some easier instruction.
 
You could try placing your subforms on seperate pages of a Tab Control then manipulate the visible property and/or active page of the tab control as appropriate
 
. . . or [blue]add a button that toggles visibility proper[/blue] . . .

Calvin.gif
See Ya! . . . . . .

Be sure to see thread181-473997
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top