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
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
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.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
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)>
That makes sense to a non-wizard user!the Form Wizard generates...a Form
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
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.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description