I'm sure this is out there in the archives somewhere, but I haven't hit the correct sequence of keywords to get me to it...
I'm writing an "Incident" database. For each incident, there's a given "Action" subform. For each Action, there is also a continuous "Materials" subform within it. In this "Materials" subform is a combo box (cmbMaterial) that lists rebar, brackets, etc.
For each incident, multiple actions may be taken over time, and each action might use different materials.
The problem is that after the user chooses a given material from cmbMaterial, I want it removed from the list of options; i.e., if the first range of choices was "Rebar, Bracket A, fencing", and the user chooses "Rebar", I want the next range of options to be "Bracket A, fencing" only.
Ideas, suggestions, links to those prior emails I missed??
thanks!
I'm writing an "Incident" database. For each incident, there's a given "Action" subform. For each Action, there is also a continuous "Materials" subform within it. In this "Materials" subform is a combo box (cmbMaterial) that lists rebar, brackets, etc.
For each incident, multiple actions may be taken over time, and each action might use different materials.
The problem is that after the user chooses a given material from cmbMaterial, I want it removed from the list of options; i.e., if the first range of choices was "Rebar, Bracket A, fencing", and the user chooses "Rebar", I want the next range of options to be "Bracket A, fencing" only.
Ideas, suggestions, links to those prior emails I missed??
thanks!
