Subject Re: Filter From Mervyn Bick <invalid@invalid.invalid> Date Wed, 15 Dec 2021 09:10:34 +0200 Newsgroups dbase.getting-started On 2021/12/14 15:04, Agostinho wrote: > Dear Mattia thank you for the advice > I will give a try, > Have a good day > Agostinho If you want to follow the route suggested by Mattia the following in the Command Panel will do the trick. update debiteur set betj_n = 'n' where betj_n is null or betj_n = ' ' After you have done this form.debiteur1.rowset.filter = "betj_n = 'n'"  will show all unpaid records form.debiteur1.rowset.filter = "betj_n = 'j'"  will show all paid records form.debiteur1.rowset.filter = "" will show all records. Mervyn.