Mircrosoft Access: Opening a sub form with a command button

[eberry707]

I have created a form and want to open the sub form with an on click command button. Is this possible? The only way I can view the subform is to have it embedded into the form. I want to have it hidden and open with the click of a command button embedded inside of the form itself

[debasisdas]

Question moved to Acess forum.

[NeoPa]

Thanks Debas :)

To show and hide the subform, set the .Visible property of the SubForm item in your code.

[eberry707]

NeoPa:

Thanks for the update. I am now able to hide the subform, but I am still having trouble opening (viewing) the hidden subform with the use of a "open form" command button? Is this possible?

[NeoPa]

It's going to be difficult to get a form to show on the clicking of a command button on that form if the form starts off invisible.
Can you let us know if this is what you're thinking of or if there's other forms involved. If so, what and where are they (Names etc).

[eberry707]

Well I have a lot of fields that will not fit on one page of the form. I am attempting to have some of the fields listed on the first page of the form, and then click a command button that opens the remaining fields on a second page (sub form)? Maybe I can set the properties of the subform and have it built in to page one of the form and click a button to maximize the subform (drop down list)?

thanks

[NeoPa]

Have you considered using tabbed pages on your form?
That is the usual way to handle situations of this nature.

[DosR]

You may also extend the length of the details section of the form to include all controls you need, use a page break control at the end of the visible area in the form margins,and finaly include buttons to move from one page to the next.

DoCmd.GoToPage 2

DoCmd.GoToPage 1

I'm using this and is very easy and confortable.

[eberry707]

Thank you for all of your help

[NeoPa]

No problems. I hope it helped.
Welcome to TheScripts :)