My goal is to create a macro that will automatically create 3 records, populating each with a different site in the <Site> field.
I have created a data entry form with a data entry Subform. When data is added to the form, <Form ID> is automatically updated in both the form and the Subform. <Form ID> is the relational field and is the key for the Form table. For each record in the Form table, there can be many records in the Subform table. I would like to create a macro that once the <Form ID> is updated in the Subform:
- Subform Record 1 is completed by + field <Subform ID> being automatically updated + field <Site> is populated with XX.
- Create Subform Record 2 with same <Form ID> + field <Subform ID> being automatically updated + field <Site> is populated with YY.
- Create Subform Record 3 with same <Form ID> + field <Subform ID> being automatically updated + field <Site> is populated with ZZ.
Notes:
XX, YY, and ZZ are consistent known values.
By adding the records for each site, it will trigger each site to complete populating data in the Subform.
I haven't created a database in over 10 years, so I am sorta like a newbie, in some respects. Your help will be truly appreciated, as I have mulled over this for 2 days. Thanks!