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

%3CLINGO-SUB%20id%3D%22lingo-sub-1682539%22%20slang%3D%22en-US%22%3EAdding%20a%20new%20sheet%20in%20existing%20form%20-%20is%20it%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1682539%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20form.%20In%20that%20I%20need%20to%20add%20a%20sheet(like%20in%20excel).%20So%20when%20you%20open%20you%20can%20select%20between%20select%20sheet%20one(CMDB)%20ore%20sheet%20to%20be%20created(Decommed%20Servers)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20add%20another%20sheet%20in%20Access%20in%20same%20form%20next%20to%20CMDB%20sheet%3F%20See%20attachment.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1682539%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1682795%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20a%20new%20sheet%20in%20existing%20form%20-%20is%20it%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1682795%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F798480%22%20target%3D%22_blank%22%3E%40MichaelF35%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20do%20this%20with%20subforms.%26nbsp%3B%20First%2C%20create%20(sub)forms%20for%20CMDB%20and%20Decommed%20Servers.%20I%20called%20them%20SubCMDB%20and%20SubDecommedservers.%20Next%2C%20create%20a%20blank%20form%20and%20add%20the%20subforms%20to%20the%20blank%20main%20form%20through%20the%20Design-tab%20with%20this%20control%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22subform.png%22%20style%3D%22width%3A%2053px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F219480iFEE484D15879F1AD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22subform.png%22%20alt%3D%22subform.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EYou%20can%20place%20the%20subforms%20next%20to%20each%20other%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sub1.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F219481i63669D4F0E89E2DF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Sub1.png%22%20alt%3D%22Sub1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20when%20you%20open%20the%20form%20in%20View%20mode%20it%20looks%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sub2.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F219484i83241E1FC606C3B0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Sub2.png%22%20alt%3D%22Sub2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20fulfills%20your%20request.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20wishes%2C%3C%2FP%3E%3CP%3ETieme%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1682892%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20a%20new%20sheet%20in%20existing%20form%20-%20is%20it%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1682892%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F131546%22%20target%3D%22_blank%22%3E%40Tieme%20Woldman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20but%20forms%20does%20not%20come%20up%20as%20sheets%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MichaelF35_1-1600421106277.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F219490iFC926C84AF2D1194%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22MichaelF35_1-1600421106277.png%22%20alt%3D%22MichaelF35_1-1600421106277.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MichaelF35_2-1600421364085.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F219491i2ACD2C42EE9D8F0B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22MichaelF35_2-1600421364085.png%22%20alt%3D%22MichaelF35_2-1600421364085.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

 

 

5 Replies

@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:

subform.png

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

Sub1.png

 

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

Sub2.png

 

Hope this fulfills your request.

 

Best wishes,

Tieme

 

 

 

@Tieme Woldman 

 

I tried but forms does not come up as sheets:

 

MichaelF35_1-1600421106277.pngMichaelF35_2-1600421364085.png

 

 

You need to use Multi TAB Form,,, or just Right Click & add TAB/Page.

@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.

 

datasheet.png

@MichaelF35 

PMFJI:
I would do this on a tab control unless you want to see both subforms simultaneously. 
inserttablecontrol.png

 

On the tab control you can insert many subforms, each of which is, in turn, displayed as a datasheet.

FormDatasheetView.png

 

Finally, I think your future ACCESS development work will go much smoother if you try to focus more on the Access environment and much, much less on the Excel environment. Excel is a wonderful tool for the purposes it is intended for, but Access is a much better tool for developing relational database applications. And that's what you are now developing.