Need Suggestion or Code for a Database

[mikej2505]

Ok...Good Morning fellow database enthusiast!



So here is what I am needing to assistance with. I have a database where the employees in my organization submit questions to their managers regarding work related issues. I created the database because I wanted to be able to capture all the questions from the employees so that I could develop training material relevant to the question to help the employees make more independent decisions.

So what I am having trouble with is below I have a label "questions pending" and next to it I cut and pasted the count results from a report that I created in the database which counts all the unanswered questions...this way the managers can open up the database and see unanswered questions without having to log into the portion of the database which is password protected.

The problem is the report in access that I have defined as "Total Count" updates just fine on its own...but I want to figure out a way so the number shown below updates in conjunction with the report results. Is there a way to run code which updates the report upon load and then to cut and past the count results automatically into the window below? Or am I going about this all the wrong way and perhaps there's a simpler solution?

Thanks for any assistance or recommendations in advance!

Mike

[pbaldy]

Are you familiar with the DCount() and DLookup() functions? I would expect one of them to solve your problem.

[JoeM]

The problem is the report in access that I have defined as "Total Count" updates just fine on its own...but I want to figure out a way so the number shown below updates in conjunction with the report results. Is there a way to run code which updates the report upon load and then to cut and past the count results automatically into the window below? Or am I going about this all the wrong way and perhaps there's a simpler solution?

If I am understanding you correctly, I don't think you should need to "Cut and Paste" anything. All your Forms and Reports should be driven by your underlying data (tables & queries). So if data is updated, the Control Sources that your Forms and Reports run off of should also automatically be updated. The only thing you might need to do is refresh your Report/Forms to reflect changes that have happened after that object was opened.