Combo box that doesnt allow previous selections [in a continuous form]

[Cruz]

Are these possible to create in Access? For example, say the list is populated from a select statement that selects all the products from a table. SELECT * FROM table. Now, in a continuous form, when the user selects product #1, the next dropdown box does not contain product #1 for selection, only 2 and up. etc etc etc. Any ideas?

 

[dcx693]

I could be wrong, but I don't think this is possible in a continuous form. The recordsource for a combo box would be the same for all records on the form. You could set it up where combo box would not accept values previously chosen by using code, but I don't think you can hide them from being displayed. Hiding them for one box would hide them for all of the combo boxes.

 

[Cruz]

How would I go about doing that later option? Hiding the option is not a big deal, I just need to prevent duplicate entries.