cascading combo box subform data filter

[Jaymin]

I have a form with three cascading combo boxes and data is entered via a subform, the third combo box will only ever have four entries in it max.
i can fill the subform in, them requery the form and select another item from the third combo or exit the form.
What i want to do is that every time i requery the form and go back to the third combo box, the item that i selected previously is removed from the combo box list, and so on till no more item are left. or the form is closed down.
Peter

 

[RainLover]

Based on my understanding.

You may be better off requering the Combo Boxes rather than the Form.

 

[Jaymin]

Rain lover,
Thanks for you reply, i did not describe what was going on properly, and yes that is how i have done it, what i want to happen is when i requery the combo box after creating a record, is to filter that item from the list so instead of 4 choices there would be only three, till no more items are left. or the form is closed down.
Peter