Display a hiden form

[chuck555]

Modifying a copy of an already working mdb to use only two of the forms. In the working copy, first form in view has list boxes and combo boxes to select information for viewing. A command button is then pressed to display another form showing the querried information. When viewing is done, a command button is pressed to close the viewing form and display the selection form.

The mdb was modified so the public can only use the controls on the two forms by setting properties of both forms
- popup - yes
- modal - yes
- boarder style - none.

The above property settings keeps the viewing form hidden behind the selection form.
So, how to display the hidden viewing form?

[June7]

Don't set the selection form as popup or modal.

[chuck555]

If I don't use popup and modal, how then to obtain the needed user restriction to only the controls on the two forms? The two properties can not be changed at run time.

- found an exe file that will remove (and restore) the Windows task bar at the bottom
- [code] CommandBars.ActiveMenuBar.Enabled = True [code] hides the form menu bar line

How then do I disable or remove the Access blue title bar at the top? A few days ago, I posted a thread to this question in the Access section and came up with popup and modal

[June7]

I just tested the BorderStyle property set to None and Popup and Modal set to No. There is no border or title bar.

The first form can be Modal but not Popup and the second form will then be on top.

[chuck555]

In my 2000 version, Boarder Style - none, popup - no and modal - no; still shows
- Access blue title bar at top
- Form gray menu bar
- Windows taskbar at the bottom

[June7]

Sorry, can't help with 2000. I guess MS has changed these properties behaviors since 2000.

[chuck555]

Keeping the property settings at the thread start, worked around with some vba

After "select" form opens the "view" form, [code] DoCmd.Close acForm, "selectimages" [code] in the "view" form displays the "view" form. Found a 3rd form was still needed which opens from "view" form. So in "details" form the same docmd display this. Closing "details" opens "view" and closing "view" displays "select"