Holding Data

C

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
 
D

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
 
Top