Sounds like you're using what's known as cascading combos.
If I want to create a system where the values from each combo box update are saved, how would I best go about doing that?
Easiest is to use bound combos, which creates the situation where their values can be arbitrarily changed. Best might be to keep them unbound but you will have to use code to create the record(s). To do that, you need a trigger - likely a button click event which should first validate as many aspects of the values that you deem necessary. Likely the least would be which combos have values. You might want to disable/enable the button using the after update event of the last combo.
Are those your real field names?
Last edited by Micron; 09-09-2021 at 09:39 AM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.