Avatar of Andreas Hermle
Andreas Hermle
Flag for Germany asked on

DCount field to be updated immediately

Dear Experts:

I got an unbound text field on a form ...
.. that displays the number of occurrences in which the checkbox (chkAuthor) is checked off.

=DCount("[chkAuthor]";"tblArticle";"[chkAuthor]<>0")

It works correctly. How can I get Access to UPDATE this form field IMMEDIATELY after I have checked off another checkbox (chkAuthor).
Now I often have to move thru several records in the form till this field gets updated.

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
Microsoft Access

Avatar of undefined
Last Comment
Gustav Brock

8/22/2022 - Mon
SOLUTION
als315

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
als315

DCount, of course
SOLUTION
Dale Fye

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Andreas Hermle

ASKER
Dear cactus_data and als315:

thank you very much for your swift help. It works just fine but only if I put your snippet into the 'Form_Current' Procedure. The AfterUpdate event does not work with me. Maybe you got my question wrong.

Buy anyhow thank you very much for your great help with this code snippet.

Hi fyed: no it is not a continuous form. Should I use one in the future your code  snippet will come in handy.

Regards, Andreas
Gustav Brock

I meant the AfterUpdate event of the checkbox you check off.

/gustav
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Andreas Hermle

ASKER
Hi gustav,

ok, got it.

Thank you very much for your professional help.

Regards, Andreas
Andreas Hermle

ASKER
Dear all,

it is always very hard for me to award points equitably since I can learn from every answer.

Again, thank you very much for your time taken and the valuable / professional help.

Regards, Andreas
Gustav Brock

You are welcome!

/gustav
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.