Critique
I’m still working on subforms & trying to get them to work, I’ve yet to create a successful one that does exactly what I want. But I thought I’d throw this out & see if it’s possible. I’d like to use an unbound main form with a subform in it to retrieve a specific set of records.
I was thinking of my main form having primarily unbound option buttons, and unbound text boxes.
Below is what I sketched out to happen:
1. Open the form.
2. The form ought to show an empty subform.
3. None of the main form controls should be selected, they should be empty.
4. Select type (main form option button)
5. Filter subform by type.
6. Select region (main form option button)
7. Filter subform by region.
8. Enter event numbers as a parameter list, since there can be more than one event being updated at a time (main form command button)
9. Filter subform by event numbers entered as parameters.
10. Enter a date in an unbound text box (main form unbound text box)
11. Choose a field to apply the date against (main form option button)
12. Step 11 will automatically update the subform records with the date specified in step 10 against the field chosen in step 11.
I’m still working on subforms & trying to get them to work, I’ve yet to create a successful one that does exactly what I want. But I thought I’d throw this out & see if it’s possible. I’d like to use an unbound main form with a subform in it to retrieve a specific set of records.
I was thinking of my main form having primarily unbound option buttons, and unbound text boxes.
Below is what I sketched out to happen:
1. Open the form.
2. The form ought to show an empty subform.
3. None of the main form controls should be selected, they should be empty.
4. Select type (main form option button)
5. Filter subform by type.
6. Select region (main form option button)
7. Filter subform by region.
8. Enter event numbers as a parameter list, since there can be more than one event being updated at a time (main form command button)
9. Filter subform by event numbers entered as parameters.
10. Enter a date in an unbound text box (main form unbound text box)
11. Choose a field to apply the date against (main form option button)
12. Step 11 will automatically update the subform records with the date specified in step 10 against the field chosen in step 11.
