I want to input a value, then use that value in an update query and a report?
I presume that I need a global value?
Any suggestions?
I want to input a value, then use that value in an update query and a report?
I presume that I need a global value?
Any suggestions?
Seems like an odd requirement. To prevent it being used again, you'd need to add the value to a table. Check that table, if it's been used stop, else add it to the table and run your report.
Really?
I want to change the value of a field when the report is run. Initially it is set to a default value, so the new entries can be reported, then set to another value to prevent it being reported again.
I know I can run an update query to do this. But can I get the report to run the query? Any other ways of doing it.
You could create a print flag and update the flag when the record is run on the report.
You can run the query from the same button that opens the report, or from the load event of the report. Both can use a textbox on the form for the criteria.