make a report popup and modal in access 2000

[Mole]

Hi , I have a report that I want to make Popup & Modal in Access 2000
(because the Access program is hidden) but cannot find the properties to set.
On Access 2003 you just go to properties for report and select yes to Popup &
Modal. These property values do not come up in the list in Access 2000. Any
ideas would be much appreciated .

 

[fredg]

Hi , I have a report that I want to make Popup & Modal in Access 2000
(because the Access program is hidden) but cannot find the properties to set.
On Access 2003 you just go to properties for report and select yes to Popup &
Modal. These property values do not come up in the list in Access 2000. Any
ideas would be much appreciated .

If I remember correctly, making a Report Modal is not an option in
Access 2000. It is available in Access 2002 and 2003.
If you are trying to show the report and it is hidden behind another
form, make the other form not visible. Make it visible again when the
report is closed. Both can be done using code.

 

[Mole]

Hi Fredg, Thanks for reply, I have tried as you suggest on an onclick event &
then onclose event of report to reshow, but because the program is actually
hidden from the users view (only switchboard, forms & reports show on desktop
Access is not visable to user) it makes the program visable which means I
will have to rehide the program again, getting a bit complicated now.