hot to set a report on top on a form

A

Alain

Hi ,
I would like to know if there is a way to set a report on top a switchboard
form when I want to view it, the report is being selected from popup/modal
forms that I close when I select the report to view, my problem is when my
popup is closed my report is opened but I cannot see it unless I click on it
from the taskbar. what I need is to view the reports instead of my
switchboard form : here is the code I use

Private Sub btnGenerateReport_Click()
Dim strWhere As String
If cboDivision.Value <> "" Then
DataExchange.SetHeading cboDivision.Value
DoCmd.OpenReport "rptRentRoll", acViewPreview, , "Division like '" &
Me!cboDivision & "*'"
DoCmd.Close acForm, "ReportGeneratorFr", acSaveNo
DoCmd.Maximize
Else
MsgBox "Veuillez sélectionner une bannière de la liste déroulante."
Me.cboDivision.SetFocus
End If
End Sub

Can anybody know how to do this ??

TIA
Alain
 
Top