I'm not sure if this is best in the Forms, queries or VBA sections.
Also i might be doing this completely wrong, please let me know.
I have a form that is showing some stats about factory production levels. when the factory finish building a product they will log the test within the database as a pass or fail.
I have created some queries to show a few different levels of detail:
*Jobs built by day
*Tests passed / failed by day
*2nd checks passed / failed by day.
I then have a form with an unlinked text box serving as a date selector field.
when the form loads i have a few VBA Dcount and DSum calcs that are run off of the queries.
My problem then comes when I try to update the date and choose to look at another date. I cannot get the queries to re-run as they are stuck using the date provided when the form opens.
Is there a way to create some sort of "refresh" button that would then force the queries to re-calc using the updated date from the form?
The only other way I can think of is to have more tables as "temp" tables and then run delete / append queries to update the data.
Also i might be doing this completely wrong, please let me know.
I have a form that is showing some stats about factory production levels. when the factory finish building a product they will log the test within the database as a pass or fail.
I have created some queries to show a few different levels of detail:
*Jobs built by day
*Tests passed / failed by day
*2nd checks passed / failed by day.
I then have a form with an unlinked text box serving as a date selector field.
when the form loads i have a few VBA Dcount and DSum calcs that are run off of the queries.
My problem then comes when I try to update the date and choose to look at another date. I cannot get the queries to re-run as they are stuck using the date provided when the form opens.
Is there a way to create some sort of "refresh" button that would then force the queries to re-calc using the updated date from the form?
The only other way I can think of is to have more tables as "temp" tables and then run delete / append queries to update the data.