Access - setting a field's dropdown/lookup programatically?

I have an Access table in a subform datasheet that I want to apply combobox style dropdown/lookup lists to.
But, as each field is set to an item from the dropdown list I want to remove that option from the other field dropdowns, since it's already assigned.

Is there any way to manipulate these programatically via VBA?

Thanks, DaveBo