Setting Modal and PopUp Properties to True (Access 2000)

**boomer99** · 2003-12-09 15:03

In Access 2002, you can set the properties of a report so that modal is yes and popup is yes. In 2000, this option is not available. Is there any way to VBA this code on the on open event?

Thanks

**charlotte** · 2003-12-09 15:10

No, but there might be other workarounds if you explain the problem you're trying to solve. For example, if you maximize the report in code when it opens and make sure any forms, etc., are hidden, you'll get the same effect.

**boomer99** · 2003-12-09 15:14

I have a form that has its setting to be a modal and popup. The command buttons open both forms and reports. I want to still keep the main form popup and modal form, but have the ability to see the report without closing the main form. Is there code that will hide my main form so the report can be seen?

**D Willett** · 2003-12-09 15:35

You could use the "Visible " property:

Private Sub Report_Open(Cancel As Integer)
Forms!FrmMyForm.Visible = False
End Sub

Private Sub Report_Close(Cancel As Integer)
Forms!FrmMyForm.Visible = True
End Sub

**charlotte** · 2003-12-09 16:19

If you hide a modal/popup form, you can popup something else, including a report. Use Dave's suggestion and don't forget to make the form visible again when the report closes..

Thread: Setting Modal and PopUp Properties to True (Access 2000)

Thread Tools