Access 2016 not giving subform option in form wizard

[Byldavis]

When I try to create a subform with the form wizard, after selecting fields from two different tables (Table Relationship set up), the wizard skips the step that gives you the subform option.


I'm no sure what I'm missing here.

Thanks,
Bill Davis

[Micron]

I hardly ever use wizards, but I don't think you can create a subform by referencing more than one table, regardless. You would have to base the form on a query that uses those tables. I would test this query first to see if it's editable or not (assuming it needs to be), before bothering with a form. That's my philosophy for forms and reports anyway.

[Missinglinq]

There is no 'subform option' in the Form Wizard...the Form Wizard generates...a Form!

Once you're in Design View for your Main Form...you can place a Subform Control on it and select the Form you want as a Subform as its source.

And yes, if you place Fields from multiple Tables on a Form...Access generates a Query as the Record Source...and they're often not editable.

Best practice is to limit one Form to a single Table (or a Query only holding data from a single Table.)

Linq ;0)>

[Micron]

the Form Wizard generates...a Form

That makes sense to a non-wizard user!

[mike60smart]

Hi All

When you use the Wizard you can select the Table for the Main Parent Form and then Select the Table for the related Child Table.