Hello. I was wondering if anyone could give me some assistance.

Basically I have a fairly simple db with a report that is based on a query that I wrote. The db is kinda like a project tracking db. I have a report button my form that will generate the report mentioned about. What I really want to do is have like a full screen dynamic report that will show all current cases. If a change is made or a record is added, the full screen dynamic report will automatically update. I believe this can be done, but I am just lost when trying to create it.

Any help is appreciated.

Thanks!

Hi vivid94 (what is your name?)

"What I really want to do is have like a full screen dynamic report that will show all current cases"

what is the criteria for Access to determine this?

setting report filters
http://www.utteraccess.com/forums/showflat...p;Number=700938

My name is Mandi - and thanks for writing back.

Right now on my main form there is a check box for "in report". Then I have a report query that runs and checks for that checkbox and will only display what records that have the "in report" checkbox checked.

My report right now is just a regular access report - but I am looking for something dynamic. So once I enter in new records or change a record - the report automatically updates accordingly. Does that make sense?

Hi Mandi,

did you read the link I gave you? I think you will find your answer ... if you have questions on how to implement it, please post back.