Hi,
I have a query which runs the following syntax to show the inventory totals for all products based on a specific date (Onhand is the function to calculate the inventory totals):
OnHand([Product_Code],Format([Enter stocktake date to report on],"mm/dd/yyyy"))
In this instance the user enters the date of a stocktake to show every product's inventory total for that stocktake in the report. Current they enter the date through a parameter box but I would like to improve this so the user uses a form with a date formatted text box to enter the date to run with the query when the report opens.
The query is called Stocktake_Accounts_Report_Query
The report is called Stocktake_Account_Report_Report
The textbox is called Text16
The command button to run the code and open the report is called Command14
How should I approach the code to get this to work?
Thanks,
Chris
I have a query which runs the following syntax to show the inventory totals for all products based on a specific date (Onhand is the function to calculate the inventory totals):
OnHand([Product_Code],Format([Enter stocktake date to report on],"mm/dd/yyyy"))
In this instance the user enters the date of a stocktake to show every product's inventory total for that stocktake in the report. Current they enter the date through a parameter box but I would like to improve this so the user uses a form with a date formatted text box to enter the date to run with the query when the report opens.
The query is called Stocktake_Accounts_Report_Query
The report is called Stocktake_Account_Report_Report
The textbox is called Text16
The command button to run the code and open the report is called Command14
How should I approach the code to get this to work?
Thanks,
Chris