Check boxes in continuous subform

[Karl Roes]

Thanks Turtle, but ... what for ? Could you please explain a little
more.
I am wanting to know the status of all check boxes in a continuous
form ie. all are 'ticked'.

MacDermott wrote -

You'll need an extra field in the table underlying the subform.

"Karl Roes" <ka******@hotmail.com> wrote in message
news:7c**************************@posting.google.c om...

Hi all,

Is it possible to check the status of the check box on every record in
a continuous subform ( one check box per record ).

I am wanting to check the " Approved " status of all subform records
in the Before_Update event of a main form combo.
Thanks and regards

Karl.

[MacDermott]

If you put a checkbox on the form without binding it to a field in the
recordset (underlying table), it will behave the same for each record -
tick one, they're all ticked; untick one, they're all unticked.
In order to keep the information for each record separate, you need to add a
Yes/No field to the underlying table, and bind your checkbox to it.

If you'd like to post a few more details on what you want to do with the
information you garner, perhaps I can help with the coding...

"Karl Roes" <ka******@hotmail.com> wrote in message
news:7c**************************@posting.google.c om...

Thanks Turtle, but ... what for ? Could you please explain a little
more.
I am wanting to know the status of all check boxes in a continuous
form ie. all are 'ticked'.

MacDermott wrote -

You'll need an extra field in the table underlying the subform.

"Karl Roes" <ka******@hotmail.com> wrote in message
news:7c**************************@posting.google.c om...

Hi all,

Is it possible to check the status of the check box on every record in
a continuous subform ( one check box per record ).

I am wanting to check the " Approved " status of all subform records
in the Before_Update event of a main form combo.
Thanks and regards

Karl.

[jv]

Perhaps do a quick lookup such as

if isnull(DLookup("Approved","TableName","Approved=0 AND .....)) then
'either all records are checked or there are no record in the
subform
end if