How to display certain records

[Carol]

I have a form that displays claims that have been worked
on and claims that are not yet completed.

Is there any way to have some type of system maintenance
function that will clear out all completed claims and
only display the uncompleted claims without using a
query?

Thanks.

 

[John Vinson]

I have a form that displays claims that have been worked
on and claims that are not yet completed.

Is there any way to have some type of system maintenance
function that will clear out all completed claims and
only display the uncompleted claims without using a
query?

Thanks.

You can set the Filter property of the form. For instance, you could
select any record with an uncompleted claim and click the "Filter by
Selection" icon.

What do you have against queries? They are the heart and soul of any
useful Access application!


John W. Vinson[MVP]