Traditional Internet Menus with Access?

[Graphfixz]

HI,

I have a database with a few forms. I am able to open forms using the Switchboard, however, I don't like closing and openning forms.

Is it possible to have one form with a navigational scheme that opens the forms inside one form? I am kind of looking to duplicate an internet menu where you click to go from page to page.

Thanks in advance.

 

[dcx693]

You can set up a form to be the main form and have other forms open within that form as subforms. The header and footer of the main form can stay there, and you can even have a sidebar or two for navigation. Only the content of the subform will change.

Or you can use a tab control with hidden tab names. When you click a link in the form, the tab control will go to different pages.

 

[Graphfixz]

Thanks for the help!

Another question is: Would I have a subform for every form that i want to open (10 subforms total with 10 buttons in tha nav.) or is there a way to open all forms inside one subform depending on what button is clicked?

 

[dcx693]

You can just have one subform control on your form and swap out the source of that subform control based on what nav button is pressed. That way, there are less objects on your form.

Use code like this:

Select Case NavButton
    Case 1
        Me.subForm.SourceObject="fsubOne"
    Case 2
        Me.subForm.SourceObject="fsubTwo"
End Select

You can make the Access form look even more like a web page by using mouse rollover effects on text labels. Investigate the On Mouse Move event.