How do I create a subform?

[walkert]

How do I create a sub form within a form?

 

[fkegley]

The easiest way is to use Form Wizard.
Select first table.
Select fields.
Select second table, related to First table.
Select fields.
Follow steps in wizard.

 

[LittleSmudge]

First design your subform as a form in it's own right.
( In the design phase there is no difference between a form and a subform - indeed I have databases where a form can appear in it's own right as a form - or can be used as a subform within another form. )

If this is intended to be a permanent subform, however, I tend to call is subfrmXxxxXxxxx to differentiate it from all the main forms that start frmXxxxxXxxxx . That way, when you are looking for a subform in a list of 100 forms then they are easier to find.

Save the new sub form.

Create ( or Open - if it exists already ) the Main Form
Select the SubForm/Report control from the toolbox.

Allow the Wizard to do most of the hard work and select the newly created subform when the wizard prompts you.


Fine tinkering may be necessary - depending on what you're doing - but you will, by now, have a subform on your main form.


QED.

G LS

 

[DougP]

Open the Form in Design view.
Click the “View” menu then “Toolbars” then “ToolBox”
This will turn on the tools needed to work with forms.
I dock mine on the left side
Now on the toolbar look near the bottom for an Icon that looks pushed in.
If you hold you mouse over each button a tool tip will pop up showing what each one does.

Next find a place on your main form where you want the sub form to be.
Then simply click on the left corner of where you want the sub form to start and drag across to the right.
If you have the Wizards installed it will prompt you for a table or query and so forth
DougP, MCP