I have a drop down box in a form to select 1 of 10 options. I would like to create a macro that when a button is pressed, the option that is selected populates a field in a continuous subform within that form.
For example:
In the sample picture I have attached, I would like to put a button near the drop down called "Select" and when it is clicked, it automatically populates the field "ID" in the subform, below. One caveat, is that if I select multiple choices from the drop down, it would need to populate multiple IDs in the subform, which is a continuous form.
Any recommendations for how to approach that?