Removing result from query with checkbox

[lewis1682]

In my database I have a form which has some textboxes set up, these are linked to a query called "Filter_Contacts" Below these textboxes is a subfrom which shows the query's results. I then have buttons set up to create mailing labels with the results. What I would like to do is include a checkbox in the results to be able to remove so it is not added to the mailing list.



Has anyone got any idea of how to do this? Thank you.

[June7]

Would need a yes/no field in the table to apply filter criteria to then bind checkbox control to the field.

[lewis1682]

Okay then what will I need to do so if checkbox is yes then remove from query so it doesn't print there label

[June7]

Apply filter to the report to exclude (or include) the records checked Yes.

You might find this discussion of interest https://www.accessforums.net/forms/y...ter-37393.html

[lewis1682]

Thank you that works perfectly