I have a subform  with an Item field(dropdown). I would like to remove an item from this dropdown if it was selected in a previous row in the subform.

how can I achieve this?

any help will be appreciated