Results 1 to 1 of 1

Thread: How do I add a SubForm to a Form?

  1. #1

    Thread Starter
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,710

    How do I add a SubForm to a Form?

    There are several ways to add one form to another form creating a form within a form (sub form). You can use the SubForm Wizard (Fig.1) from the Controls Toolbox.

    Fig. 1





    Draw your subform on to your form from a top-left position to a lower-right position that will define your subforms size and location as shown in Fig. 2. When you release the left mouse button the SubForm Wizard will popup as shown in Fig. 3

    Fig. 2





    Choose your pre-existing form or choose to have the data come from a Table or Query. I already made a form I wish to use so I am choosing "Use Existing" and selecting the form from my list as shown in Fig. 3.

    Fig. 3





    Choose the fields to link the forms together with or choose from a pre-defined list of possible links. Available fields are dependant upon chosing a pre-made form or linking records from a pre-defined table or query. For this example I will be choosing the pre-made form as shown in Fig. 4, selecting the fields to link, then click Next.

    Fig. 4





    Enter in a name for your subform if you would like to change it and click Finish.

    Fig. 5





    Now your SubForm will appear in design view in the area you drew out from Fig. 2 Now click on the View Form button or via the menu to run your form with its newly added SubForm shown in Fig 7.

    Fig. 6





    Your done now as your form is displaying your SubForm (Fig. 7).

    Fig. 7





    I also provided a Windows Media Player video file (zipped with WinZip) showing the above steps.
    FAQ's OD: How to add a Subform video (139k)
    Last edited by RobDog888; Jul 9th, 2006 at 06:39 PM.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width