Reducing the List items on a combo

Can someone help on this problem.

I have a combo box of, say three Items, selected from a table that
serves as the lookup: E.g. 1 Earth, 2 Pine, 3 Earth Grave
The combo box is on the subform.

If the user selects any of the item, that item so selected should not
appear in the list again; or
The user should be warned about previous selection.

I dont want the user accidentally selecting the same item out of
error.

Will be grateful if someone can give me a solution.
.

Relevant Pages

  • Re: pop up form by selection
    ... to make a selection and pop up the form assinged to each selection. ... "Jeff Boyce" wrote: ... You are trying to get a different subform to display, ... On your main form, add a tab control. ...
    (microsoft.public.access.forms)
  • Re: pop up form by selection
    ... to make a selection and pop up the form assinged to each selection. ... "Jeff Boyce" wrote: ... You are trying to get a different subform to display, ... On your main form, add a tab control. ...
    (microsoft.public.access.forms)
  • Re: pop up form by selection
    ... "Jeff Boyce" wrote: ... will open other forms depending on the selection in the combo box. ... the main form and the popup form opens. ... the subform (by the way, another definition for Access -- a subform is ...
    (microsoft.public.access.forms)
  • Re: Refresh Results In A Second Subform In A Form
    ... user makes their selection and the 1st subform shows ... For an example I will call the query qAccountSelections. ... Hide the second subform until you have finished making all the ...
    (microsoft.public.access.forms)
  • Re: pop up form by selection
    ... will open other forms depending on the selection in the combo box. ... "Jeff Boyce" wrote: ... the main form and the popup form opens. ... the subform (by the way, another definition for Access -- a subform is ...
    (microsoft.public.access.forms)