Using SetValue

[dcarr]

Does anyone know how I can write a macro that runs a report, that is based on an underlying query, that usually requires an input, but instead of prompting the user I wasnt to automate it for different values. The report is
Reports!repAVR4!Pubcode - where pubcode is the value I want to change on several occasions
Thanks

 

[Travis]

One way to do this is to create a form with an unbound text box on it. Open this form (if you don't want user interaction open this form hidden). Base the Query's criteria off of the unbound Text box. Run the Report. Add code to the Close Event of the Report to Close the Criteria Form that you have opened.