make a report to open to the right of...
Posted on 2013-11-16
In a two screens setting; the form opens in the large screen. But. upon dbl-click on a label on a the form an expected report opens in the smaller screen not on the top of the form where I am trying to get it opened.
FYI, the report is only 2 inches wide and opens in dialog mode. This report is best to open 3 inches from the left edge of the form in the large screen as well.
Question: How can I change the following code (possibly passing the left position of the report as OpenArgs)?
DoCmd.OpenReport "report1", acViewReport,,, asDialog
Or, do something in the open/ load event of the report to sense the left-position of the form to position itself 3 inches to right of it.
All works fine except that the report opens up in the laptop monitor (smaller screen) not in the large screen.