Combo Boxes

I'm writing a database in Access 97.

I have a form "frmOrders" and a subform "frmOrdersSubform", within my subform I have a combo box that gets it's records via a select query from a different table "tblProducts"

Now, when I select a particular value from the combo box I would like it to be removed, but, only from the current record.

How????

Thanks :):(

Redo your query with the condition :

where id <> the one that you want to remove.