Access 2010. How can I remove value from a combobox after it is selected

[Corwin Moyne]

Hello. Lets say I have 3 tables: jobRef, colourAnilox and aniloxTable. jobRef is a parent of colourAnilox. I have a combobox on the sub form colourAnilox that gets its list from aniloxTable. Once the user makes a selection on the combobox (aniloxRef), I want to temporarily remove this from the list as I can use it only once on each jobRef. But how can this be done?

I do not know how to write VBA so I am hoping this can be acheived using the macro designer.

[Seth Schrock]

See if this post could help point you in the right direction: How do I keep combo box value from being changed back previous value This solution would be dynamic in that it would depend on the values in the record that you are currently in and would change when you change to a different record.