dbTalk Databases Forums  

Check boxes in continuous subform

comp.databases.ms-access comp.databases.ms-access


Discuss Check boxes in continuous subform in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Karl Roes
 
Posts: n/a

Default Check boxes in continuous subform - 01-05-2005 , 04:00 AM






I'm still having trouble posting follow-ups. :-(

"Unable to retrieve message
7cc66112.0501041919.3a6628b4 (AT) po...OT) google.com"

Now Turtle wrote "You'll need an extra field in the table underlying
the subform." ....................hmmmmmmmmm...................

I put in a field in the underlying table with a default value of 1.
I created a text box which adds up the values in the new field
-(txtRecordCounter).
I created another text box which adds up the absolute total value of
the checkboxes - ( txtTotCheck).
Reference these from the main form and if
txtRecordCounter=txtTotCheck, all the checkboxes in the subform are
ticked.

This seems to work well.

Karl




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" <karlroes (AT) hotmail (DOT) com> wrote

Quote:
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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.