Using an array to complete reports

[rsewell]

I have been using an array to fill out a standard form that I use in Word format. I now have that form as a report in Access so I don't need to use the Word file anymore. All I want to do is edit my existing VBA code to open the Access Report instead of the Word file and fill in the blanks. Any help would be greatly appreciated. I'm attaching the code if anyone would like to look at it.

 

[jeremie_ingram]

I would make the neccessary edits to the field refrences within the report itself. If you can set the report to gather the data from a query, you then can limit the date that is returned based on criteria. Depending on how you need the data formatted (one month per page, one record per page) would determine how you would make the neccessary setting under the properties of the report itself. Once you have these items set properly, you should be able to open the report and all of the fields should be properly populated with the desired data.
Once the report is set as you want it, then direct the command button to open the report.
The code you posted is somewhat complex, and unneccessary if you are keeping the work all in access now. Try generating a query that returns the exact dataset that you need, then base your report on the query.