Hi,

I have a Tabular form with over 200 records containing the Clients name and
a check box,

I use this to print labels for the required clients being any that are
ticked.

Could anyone help me or tell me where I might find code that would enable a
"Select All" & "Un-Select All" buttons.

Many thanks,
Anthony.

Execute an update query against the underlying table from code behind the
buttons. Create the query in the Query Builder and copy the SQL into your
code to make it even easier.

Larry Linson
Microsoft Access MVP

"Anthony" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> I have a Tabular form with over 200 records containing the Clients name
and
> a check box,
>
> I use this to print labels for the required clients being any that are
> ticked.
>
> Could anyone help me or tell me where I might find code that would enable
a
> "Select All" & "Un-Select All" buttons.
>
> Many thanks,
> Anthony.
>
>

Hi Larry,

Thank you that worked great.

Anthony.


"Larry Linson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Execute an update query against the underlying table from code behind the
> buttons. Create the query in the Query Builder and copy the SQL into your
> code to make it even easier.
>
> Larry Linson
> Microsoft Access MVP
>
> "Anthony" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi,
> >
> > I have a Tabular form with over 200 records containing the Clients name
> and
> > a check box,
> >
> > I use this to print labels for the required clients being any that are
> > ticked.
> >
> > Could anyone help me or tell me where I might find code that would
enable
> a
> > "Select All" & "Un-Select All" buttons.
> >
> > Many thanks,
> > Anthony.
> >
> >
>
>