CODEWITHSUNDEEP
ms-accesscheckboxms-access-reports
ThatTallGuy88
ThatTallGuy88

Reputation: 29

Access form with individual record check boxes

I'm trying to have my access reports have check boxes that if you check one box in report view that one will be the only one that is checked. Currently if I add a check box in the design view and click it in the report view all of the check boxes in the report will add or remove a check mark, not just that individual box for that one record. I am unsure if there is a line in the property sheet that I am missing or that I'm missing something else completely.

Upvotes: 1

Views: 814

Answers (1)

DFAD
DFAD

Reputation: 41

Specify a control source for the checkbox. You need to hold the value for each separate checkbox alone. A checkbox without a control source (Under Data Tab in Properties) will show the same value for all records of the report record source (This is the same for forms).

For example, if you have a report showing Client Number and Client Name for all your clients, and you need to add a checkbox near each record, then the value for the checkbox should be bound to a control source from the report record source. So in the record source you should have the fields: client number, client name, and checkbox Value.

Upvotes: 2

Related Questions