Help with a form and checkbox

I am not an expert at access and I need a little help with a form. I
have a form that is linked to a table with address information. My form
has a checkbox linked to a field in the database to show when an
address has been gone through and confirmed. I would like to have a box
on the form that shows how many records have been checked and have "-1"
in the table. I don't know how to do this and I asked a consultant that
helps me from time to time and he said that it was complicated and
would take almost a day to complete.
I didn't think that it sounded like a difficult think to do and I
thought I would ask people who know more than I do. Thanks for any help.

re: Help with a form and checkbox

On 30 Jun 2005 08:27:04 -0700, morgan.mark@att.net wrote:
[color=blue]
> I am not an expert at access and I need a little help with a form. I
> have a form that is linked to a table with address information. My form
> has a checkbox linked to a field in the database to show when an
> address has been gone through and confirmed. I would like to have a box
> on the form that shows how many records have been checked and have "-1"
> in the table. I don't know how to do this and I asked a consultant that
> helps me from time to time and he said that it was complicated and
> would take almost a day to complete.
> I didn't think that it sounded like a difficult think to do and I
> thought I would ask people who know more than I do. Thanks for any help.[/color]

Add an unbound control to the form.
Set it's Control source to:
=ABS(SUM([CheckBoxName]))

Also code the Check Box AfterUpdate event:
Me.Refresh

so that any changes are immediately shown in the control.

Almost a day to do, huh!!!
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

re: Help with a form and checkbox

On 30 Jun 2005 08:27:04 -0700, morgan.mark@att.net wrote:
[color=blue]
>I am not an expert at access and I need a little help with a form. I
>have a form that is linked to a table with address information. My form
>has a checkbox linked to a field in the database to show when an
>address has been gone through and confirmed. I would like to have a box
>on the form that shows how many records have been checked and have "-1"
>in the table. I don't know how to do this and I asked a consultant that
>helps me from time to time and he said that it was complicated and
>would take almost a day to complete.
>I didn't think that it sounded like a difficult think to do and I
>thought I would ask people who know more than I do. Thanks for any help.[/color]

Add a textbox to the form. In the newly added textbox, put the
following as the ControlSource (under the Data tab in properties):

=DCount("[myfield]","mytable","myfield=-1")

Substitute the correct names for your field and your table.

Almost a day to complete, huh? I wonder what else you are paying
through the nose for?

mike

re: Help with a form and checkbox

Thank you very much for your replys. The box works great now, just like
I needed. I only used my consultant a few times, most of it was a
learning experience. I try to do it on my own now and I guess I learned
enough to ask in the right place. Thanks again.

re: Help with a form and checkbox

<morgan.mark@att.net> wrote in message
news:1120155328.113870.174440@f14g2000cwb.googlegr oups.com...[color=blue]
> Thank you very much for your replys. The box works great now, just like
> I needed. I only used my consultant a few times, most of it was a
> learning experience. I try to do it on my own now and I guess I learned
> enough to ask in the right place. Thanks again.[/color]

This is, indeed, a good place to ask.

The FAQ for this newsgroup at http://www.mvps.org/access is also a great
source of information. It even includes
http://www.mvps.org/access/netiquette.htm, which is as chock-full of good
suggestions about effectively using this and other newsgroups as the rest of
the site is full of good information about Access, and links to other
sources of information. Another site with some of the same, and a few
different, links is http://ntaccess.tripod.com.

You'll find a good many other references posted here from time to time, too.

Larry Linson
Microsoft Access MVP