Forum Discussion

MichaelF35's avatar
MichaelF35
Copper Contributor
Sep 18, 2020

Adding a new sheet in existing form - is it possible?

I have a form. In that I need to add a sheet(like in excel). So when you open you can select between select sheet one(CMDB) ore sheet to be created(Decommed Servers)

 

Is it possible to add another sheet in Access in same form next to CMDB sheet? See attachment.

 

 

  • Woldman's avatar
    Woldman
    Iron Contributor

    MichaelF35 

    You can do this with subforms.  First, create (sub)forms for CMDB and Decommed Servers. I called them SubCMDB and SubDecommedservers. Next, create a blank form and add the subforms to the blank main form through the Design-tab with this control:

    You can place the subforms next to each other like this:

     

    And when you open the form in View mode it looks like this:

     

    Hope this fulfills your request.

     

    Best wishes,

    Tieme

     

     

     

      • Woldman's avatar
        Woldman
        Iron Contributor

        MichaelF35 

        If you open the subforms in Design view you can set the forms properties for

        Default View to Datasheet

        Allow Datasheet View to Yes

        and then the subforms should be shown as sheets.

         

  • Rajesh_Sinha's avatar
    Rajesh_Sinha
    Steel Contributor
    You need to use Multi TAB Form,,, or just Right Click & add TAB/Page.

Resources