filter checkbox from form on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My inventory form has a SOLD checkbox and I don't want it to print those Sold entries on my Inventory report. But I don't want to delete that entry. Please help. Thanks
 
Jodi,

I would assume your report is based on a query and that
the checkbox is stored in a table somewhere.
Add the checkbox field to your report's query and set the
criteria in the query to false (or zero). This will
eliminate all sold items from your report.

If I have this all wrong pls post back with some more
details on your db.

HTH,

Terry
-----Original Message-----
My inventory form has a SOLD checkbox and I don't want it
Click to expand...
to print those Sold entries on my Inventory report. But I
don't want to delete that entry. Please help. Thanks
 
Back
Top