Checkbox for each record

[justin.poole]

Hi,

I have a form + subform that allows users to add records and I would
like to have them be able to delete multiple records based on the
checkbox(es) they tick. However when one checkbox is ticked in the
subform, all the checkboxes becomes selected. This will be because that
checkbox is in fact the same checkbox (with the same name) for all
records.

What is the best way to handle this sort of situation so the user can
selected individual checkboxes?

 

[Douglas J. Steele]

You'd have to add a boolean field to the underlying table, and bind that
field to the checkbox.

 

[Al Campagna]

Justin,
Add a field check field (T/F) to your subform table (ex. name [DeleteThis]). Bind the
checkbox field to that field in your subform (ControlSource = DeleteThis)
Now, each record will be able to store that DeleteThis True/False value.
Later you can run a Delete query against the subform table and delete any record whre
DeleteThis is True.

 

[justin.poole]

Thanks for your help!

Justin,
Add a field check field (T/F) to your subform table (ex. name [DeleteThis]). Bind the
checkbox field to that field in your subform (ControlSource = DeleteThis)
Now, each record will be able to store that DeleteThis True/False value.
Later you can run a Delete query against the subform table and delete any record whre
DeleteThis is True.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Hi,

I have a form + subform that allows users to add records and I would
like to have them be able to delete multiple records based on the
checkbox(es) they tick. However when one checkbox is ticked in the
subform, all the checkboxes becomes selected. This will be because that
checkbox is in fact the same checkbox (with the same name) for all
records.

What is the best way to handle this sort of situation so the user can
selected individual checkboxes?