>>
>>I meant to write recordsource=''. I tried it a few years ago, it caused all kinds of problems. My method have never failed.
>
>Both methods have pros and cons. Zap could lead to destructive and irreversible results while = "" would only effect display. I only mean it's not an uppercased "NOT" to use thing.
>Cetin

I have used the zap solution for years, and I have never had any trouble with it so far. I use it with both for small tables, and for large tables, all are DBFs. The largest I use regularly has more than 5 million records and a size of 950MB.