Counting in Subform

[aubrey]

Good afternoon all,

I have a Mainform and a Subform, which is displayed in datasheet view. On my
Subform I have a field that is a "Yes/No" checkbox. I want to populate a
field in my main Mainform based on have many records on the Subform are
checked.

If anyone can point me in the right direction that would be great.

Aubrey,

 

[Arvin Meyer MVP]

1. Add a footer to the subform.
2. Add a textbox named txtCount to that footer
3. Make its Controlsource:

= Sum([chkNameOfCheckboxControl])*-1

4. Add a textbox to the mainform
5. Set its Controlsource to:

=[NameOfSubformControl].Form![txtCount]

The value of True in a checkbox is -1. By adding them and multiplying the
sum by -1 you will get a positive count.

 

[aubrey]

Works great, thank you very much.

1. Add a footer to the subform.
2. Add a textbox named txtCount to that footer
3. Make its Controlsource:

= Sum([chkNameOfCheckboxControl])*-1

4. Add a textbox to the mainform
5. Set its Controlsource to:

=[NameOfSubformControl].Form![txtCount]

The value of True in a checkbox is -1. By adding them and multiplying the
sum by -1 you will get a positive count.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Good afternoon all,

I have a Mainform and a Subform, which is displayed in datasheet view. On
my
Subform I have a field that is a "Yes/No" checkbox. I want to populate a
field in my main Mainform based on have many records on the Subform are
checked.

If anyone can point me in the right direction that would be great.

Aubrey,

 

[aubrey]

Hi,

the below process works, in tems of the tally, but now that I have changed
the Control Source to =[NameOfSubformControl].Form![txtCount], the tally does
not populate in my table.

any thought on how to get that info back to my table

Thanks

1. Add a footer to the subform.
2. Add a textbox named txtCount to that footer
3. Make its Controlsource:

= Sum([chkNameOfCheckboxControl])*-1

4. Add a textbox to the mainform
5. Set its Controlsource to:

=[NameOfSubformControl].Form![txtCount]

The value of True in a checkbox is -1. By adding them and multiplying the
sum by -1 you will get a positive count.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Good afternoon all,

I have a Mainform and a Subform, which is displayed in datasheet view. On
my
Subform I have a field that is a "Yes/No" checkbox. I want to populate a
field in my main Mainform based on have many records on the Subform are
checked.

If anyone can point me in the right direction that would be great.

Aubrey,