Is it possible to load more than one table from one form?

[dmellman]

Hello, All! I would like to load two tables from one form. As part of this, I would like to load multiple records into one table that are associated with the one record in the other table, with the same form, like a looping routine.



Specifically, I would like to input a maintenance record in one table, including machine name, date, time used, and through the same form, enter multiple records for parts used on this maintenance job, keyed on the machine name. Or machine name/date?

Is this possible, using form design? I cannot do macros at this point. Anyone's suggestions would be greatly appreciated.

[June7]

You need to use form/subform arrangement. Main form bound to maintenance record table, subform bound to child table. Master/Child link properties of the subform container control will synchronize the records. No code is necessary.

[dmellman]

Thanks, June7. I got it.
Here is the form. It works. Thanks!