Dictating where an Access Report on the Open Event in VBA

[GISbycatfish]

I have built a form in Access that allows user's to print either one report or many reports. Unfortunately, if they were to open more than one report, the reports open with one on top of the other. I would like to find a way to distribute the reports (in preview mode) to where the user can see each of the reports. If anyone has any insight to this problem, it would be greatly appreciated.

My forms & it's events:

1 form that has 3 option buttons (for which report), 3 text fields (used to build a SQL query), a command button that builds the SQL statement from the text boxes, finds which options are selected, and opens the reports based on the SQL statement

 

[PaulF]

you can send a SendKeys statement to Open the Windows Menu and Select Tile Horizontally or Tile Vertically


SendKeys "%WT"

or

SendKeys "%Wi"

of course this will tile all open windows inside access, the form the database window... etc

PaulF