Check box: Display the number of "No" in a form

[bhaydon]

I have a checkbox which represents a "closed record". I would like to have it display the number of open records on the form. (I.E. if there are 10 unchecked boxes I would like the number 10 at the top of my form.) Thank you for any help.

 

[smedvid]

Refer to Help on "Forms Collection". I think you can loop through the Form objects and look for a Object Type of Checkbox. Then get the object name, and check if the values is "1" (I think) which indicates it is checked.

Another more simple approach, if you know all the object names is to write a simple procedure that is a set of IF Statements and then adds to a variable Counter. This Variable Counter could then populate a field on the form.

htwh,
Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[PWise]

dcount("*","tablename","checkbox=false&quot

 

[bhaydon]

I am sorry, but I am a bit of a newbie to programming. Could you detail the steps that it would take the acheive this? Thank you for taking the time to help me out