hiding forms

H

Halocarbon

I am making a database in which my users will add data to a form then they
will click a command button that runs a macro to view the information on a
report. How can I get the form to hide while they are viewing the report. I
did this in Access 97 with the send keys function and using "%W"h, then
opening the report. But in Access 2000 this does not work. Any ideas? I have
sort of fixed it by having two separate send keys functions; one to press %,
and the other to press wh. But sometimes this works and sometimes it doesn't.
Anyone know why?
 
H

Halocarbon

I only want the form to go away while the report is being viewed. Won't
setting the visible property to false make the form be hidden all the time?
Once they close the report I want the form to reappear. I just do not want
them to be able to click and bring the form to the front while they are
viewing the report.
 
R

Rick Brandt

Halocarbon said:
I only want the form to go away while the report is being viewed.
Won't setting the visible property to false make the form be hidden
all the time? Once they close the report I want the form to reappear.
I just do not want them to be able to click and bring the form to the
front while they are viewing the report.
Click to expand...

In the Close event of the Report set the visible property of the form back
to true.
 
Top