By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Check boxes in continuous subform

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.