Holding Data

[Chip]

I have a combo box that is populated based on several factors.
However, one of the factors I want is expiration date. I want to only
see persons who are not expired. So my query has a Where clause, Where
Date is > Now(). That works fine...

However, after a person does expire, what happens is my table then
removes that person and shows a blank. How do I set it up, so that it
will hold onto the value's I give it, even if that person expires.

chip

 

[Damon Heron]

your table should not be removing the record unless you have code somewhere
that is doing it.
The combobox query would not do that. Explain further, please.

Damon