removing a record after a combo choice is made

[tinmar]

I have a table which as customer details eg. Name, contact information etc. There is also a combo box which contains ( still interested, no longer interested)

I then have a form which has this combo box, the 'no longer interested is chosen, how do I make it so that this record will no longer appear next time the form opens up. But i dont really want to delete the record.

Hopefully this makes sense

 

[PHV]

The customer table should have a field holding the 'interested' info.
Then the underlaying query of the form may use this field as a criteria.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886