Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Closing a form & opening a report
25 views
Skip to first unread message
rwpe...@clear.net.nz
May 6, 2013, 12:39:35 AM5/6/13
to
I have a form "frmCustomers" on which there is a button which opens second form in to which I insert data. I then open a report based on the data entered in the second form.
My problem is that the form opens behind the frmCustomers. The second form closes OK but I would like the report to open Mazimised in the front.
stDocName = "Transfer Form"
DoCmd.OpenReport stDocName, acViewPreview
DoCmd.Maximize
DoCmd.Close acForm, "TransferMain"
I have played around with forms Popup and Modal but no success yet. Any help would be appreciated.
TIA
Regards - Ray
My problem is that the form opens behind the frmCustomers. The second form closes OK but I would like the report to open Mazimised in the front.
stDocName = "Transfer Form"
DoCmd.OpenReport stDocName, acViewPreview
DoCmd.Maximize
DoCmd.Close acForm, "TransferMain"
I have played around with forms Popup and Modal but no success yet. Any help would be appreciated.
TIA
Regards - Ray
Phil
May 6, 2013, 3:32:29 AM5/6/13
to
Docmd.SelectObject acReport, "Transfer Form"
Phil
0 new messages