This may have been answered, but I couldn't find a post. I found some close but not close enough.
I would like to have a combo box that has a list of option from either a table or query. Once a selection is chosen from the combo, it would save the record to the specified table and show the combo box again, but with the previous selection(s) removed. This would continue in a loop until you move on.
Basically, there is form1. The combo is in a subform (form2) with has a child field.
I hope that I have explained what I am looking for. I am hoping to find something that would handle normalization.
I would like to have a combo box that has a list of option from either a table or query. Once a selection is chosen from the combo, it would save the record to the specified table and show the combo box again, but with the previous selection(s) removed. This would continue in a loop until you move on.
Basically, there is form1. The combo is in a subform (form2) with has a child field.
I hope that I have explained what I am looking for. I am hoping to find something that would handle normalization.