Modal Form Problem

[human_anomaly]

I have a lot of modal forms in my database. The problem is that when I open a report the user can't do anything with it until the form is closed. Is there any workaround that would allow the user to view the report and when they close it have them go back to the modal form?

 

[Rich]

Toggle the Forms .Visible property, examples have been posted

 

[human_anomaly]

Well actually I found some code that looks like it should work. However I am having a problem running it. you can find the code here: http://www.mvps.org/access/reports/rpt0003.htm
The problem I am having is that it works great if I just specify the name of the report, but when I try to specify other things such as view or a where condition it barks at me saying that there is a "=" needed.

This works:
OpenReport ("RptFull")

This does not work:
OpenReport("RptFull", 2)
saying that a "=" is needed

anyone know what I am doing wrong?

 

[human_anomaly]

found my problem, it should look like this: OpenReport "RptFull", 2, , "[Student] = '" & Me.Student & "' and [Scenario] = '" & Me.Scenario & "' and [Date1] = '" & Me.Date1 & "' and [Teacher] = '" & Me.Teacher & "'"

However I have another problem yet again. I have 4 modal forms that I turn there visible value to false by doing this:
Form_FrmMain.Visible = False
Form_FrmViewData.Visible = False
Form_FrmSelect.Visible = False
Form_FrmData.Visible = False

this all works fine, but when I go back to make the forms visible like this:
Form_FrmMain.Visible = True
Form_FrmViewData.Visible = True
Form_FrmSelect.Visible = True
Form_FrmData.Visible = True
the third one down (Form_FrmSelect) stays false.
I have tried renaming it thinking it may have been a reserved word or something, but what really troubles me is that it can change the property to false but not to true. Does anyone know what is going on here?

 

[Rich]

try this instead

Dim frm As Form
For Each frm In Forms
frm.Visible = True
Next