>>If you have a seperate form for each report, I am sure that Forms.Add can do the job for you because you can pass a string to this method.
>
>
>Eric,
>
>I have not used the Forms.Add method before. Any tips on where I should go look to figure it out.
It should be simple in your case. See this example:
Private Sub Command1_Click()
Dim x As String
Dim NewForm As Form
x = "form2"
Set NewForm = Forms.Add(x)
NewForm.Show
End Sub
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com