Form Filter

  • Thread starter Thread starter Jason Frazer
  • Start date Start date
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
 
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.
 
Back
Top