How is this accomplished

I found this demo online and I would like to be able to open forms up
by clicking on a button to the left like this database.

Does anyone no how to set it up like this, seems pretty nice.

Has command buttons on the left and sort options. When the command
buttons are clicked another form opens within the template form. All
forms that open are different but are fitted within like a database
window.

The example is at http://armydatabase.com/test.pdf

Thanks for any help.

<dmkeith2@hotmail.com> wrote in message
news:1111880896.048891.25720@l41g2000cwc.googlegro ups.com...[color=blue]
>I found this demo online and I would like to be able to open forms up
> by clicking on a button to the left like this database.
>
> Does anyone no how to set it up like this, seems pretty nice.
>
> Has command buttons on the left and sort options. When the command
> buttons are clicked another form opens within the template form. All
> forms that open are different but are fitted within like a database
> window.
>
> The example is at http://armydatabase.com/test.pdf[/color]

The button could be changing the SourceObject property of a subform control.

Me.SubformControlName.SourceObject = "FormName"

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

So does that mean it closes the other subform and opens a new one
formatted to the same size within the window?

What about the border around the subform. I just don't understand how
it closes and opens a new one and yet leaves the template unchanged.

Thanks

My guess is that the right side is a tabcontrol with subforms on the pages.
The tabs have been turned off and buttons were created and programmed to
display the pages. If you have the demo, open the form in design view and
determine whether the right side is a tab control or subform.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com

<dmkeith2@hotmail.com> wrote in message
news:1111880896.048891.25720@l41g2000cwc.googlegro ups.com...[color=blue]
> I found this demo online and I would like to be able to open forms up
> by clicking on a button to the left like this database.
>
> Does anyone no how to set it up like this, seems pretty nice.
>
> Has command buttons on the left and sort options. When the command
> buttons are clicked another form opens within the template form. All
> forms that open are different but are fitted within like a database
> window.
>
> The example is at http://armydatabase.com/test.pdf
>
>
> Thanks for any help.
>[/color]

Thanks,

It's a demo, but it's an MDE so I can't look in design view. I believe
it is various subforms that are hidden and unhidden based on the
buttons being pressed.

Do you know how to unhide subforms and once a different button is
pressed it hides all other subforms and unhides the one it calls.

I'm sure the guy that did this database used some sort of source object
call but I'm not that good. Thanks

If you had a subform for each button, that many subforms would be
unmanageable in design view. You wouldn't be able to distinguish one from
another to work on any of them. Add a tabcontrol to your form, create as
many pages as you need and put a subform on each page. In design view, you
can click the tabs and easily go from one subform to another. When you have
the system built, turn the tabs off and then you just need to add a system
of buttons in an option group to go from one page (subform) to another. It's
a very neat system done this way.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com

<dmkeith2@hotmail.com> wrote in message
news:1111890828.309448.313540@z14g2000cwz.googlegr oups.com...[color=blue]
> Thanks,
>
> It's a demo, but it's an MDE so I can't look in design view. I believe
> it is various subforms that are hidden and unhidden based on the
> buttons being pressed.
>
> Do you know how to unhide subforms and once a different button is
> pressed it hides all other subforms and unhides the one it calls.
>
> I'm sure the guy that did this database used some sort of source object
> call but I'm not that good. Thanks
>[/color]

How would I reference the different tabs from the command buttons.
That's a good idea by the way.

Definately going with the tabs.

<dmkeith2@hotmail.com> wrote in message
news:1111893179.863607.257970@f14g2000cwb.googlegr oups.com...[color=blue]
> How would I reference the different tabs from the command buttons.
> That's a good idea by the way.
>
> Definately going with the tabs.[/color]

Tabs are necessary when the subforms need to be different sizes, but if you want
them all to be the same size there is no reason not to use just one subform and
just change the form being displayed in it. Loading multiple forms at the same
time on TabPages will be slower because even though you are only seeing one of
them at a time they are all pulling in their data when you open the form and
navigate in the main form.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Create an option group with the number of options the same as the number of
subforms. Here's the code for three subforms, you can expand it to what ever
you need:
Me!MyTabCtl.Value = Me!MyOptionGroup - 1
Select Case Me!MyOptionGroup
Case 1
Me!Subform1MyField.SetFocus
Case 2
Me!Subform2MyField.SetFocus
Case 3
Me!Subform3MyField.SetFocus
End Select

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com

<dmkeith2@hotmail.com> wrote in message
news:1111893179.863607.257970@f14g2000cwb.googlegr oups.com...[color=blue]
> How would I reference the different tabs from the command buttons.
> That's a good idea by the way.
>
> Definately going with the tabs.
>[/color]