Form Filter

J

Jason Frazer

I have a form "Invoice" that references table "Customers"
Customers table has a field that is a check box. this
field name is "OldCustomer". What do i need to put in the
filter field so that customers with oldcustomer checked
will not appear in this form

Thanks for your help

Jason Frazer
 
F

fredg

Jason said:
I have a form "Invoice" that references table "Customers"
Customers table has a field that is a check box. this
field name is "OldCustomer". What do i need to put in the
filter field so that customers with oldcustomer checked
will not appear in this form

Thanks for your help

Jason Frazer
Click to expand...

Instead of having the Table as the form's Record Source, make a query,
using the table, the record source.
As criteria for the table, in the OldCustomer field, write:
0

Only records that are NOT checked will appear on the form.
 
Top