Remove selection from Combo box

[bbrazeau]

I have a combo box that selects records to add to a subform (the many side of a join table). I have criteria in its row source query that limits possible selections to those from another table that are linked to the ID of the current record in the main form ( the 1 sides of the join)and have a certain field value "Quoting" The user selects an item from the list , presses a button and it adds the record to the subform. I would like that record not to show up in the combo box any more. How can I do that?

[orange]

Try a combobox requery in the click event of the button.

THere are free videos that may help
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

[bbrazeau]

Thank you orange for the reply. I was not so much asking how to requery the combo box as I was asking how to design criteria that would strip the list of items I had already used on this record. I have temporarily solved the problem by adding another possible field value in one of the fields that I was checking for criteria. (the "Quoting" field I spoke of in my 1st post) and setting that to "Quoted" when the user selects a value from the list and clicks the command button. That way when the combo box is requeried it strips off those possible values that are either "Quoted" or "Active" (active means they have been quoted, a PO has been issued, and they are existing Products) and leaves only "Quoting" values. However, the problem with this method is the value is not actually Quoted yet, its just put in a list of values to include in a single Quote and it can't be included in another rfq. I wanted the combo box to examine the records in the subform for the current record and strip the values used already in addtion to the other criteria it uses to form the list. that way the same value could go in other rfqs since we often have to quote many different groupings before finding one that is acceptable by the customer. I put criteria in the query that strips off the 1st record in the subform, but since the purpose of the join table (the subform) is to allow multiple items, it realy is of no use. what I need is to recurse thru the subform list to repopulate the combo box every time the user moves to the next record.