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?

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?
>

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

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?
>

Thanks for your help!


Al Campagna wrote:

> 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
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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?
> >