create a Form to update multiple tables with auto population based on sellected parameter.

[jwbeaty]

Good Morning,



I am creating a training data base to track training at multiple locations. I would like to have the form auto populate the employees from the selected location when it opens. Then have user input session leader and training module date completed for each employee. Each training module has its own table. Once the training date has been input each time the form is opened the completed dates will remain in view.

Hopefully this is possible to make.

Regards

[June7]

Anything is possible with enough code. Related records must first be created by old fashioned data entry or code that creates 'batch' of records. Then when form opens only related records are displayed. This last behavior is what form/subform arrangement manages.

[Bullschmidt]

Also you may want to look into:

Add records to a table by using an append query
https://support.office.com/en-us/art...8-8ef649cf3596

Create and run an update query
https://support.office.com/en-us/art...9-35e5ee1e0514