docmd.close forms - doesn't close the form

[Wuelf]

Greetings,

I use a form to open 3 different reports based on a chosen criteria, the
problem I have is when I close the report and I then open that same form the
previously entered criteria is still in the form. I use - docmd.close acForm,
"Criteria - Daily Report", acSaveNo - in the reports Report_Close() sub.

Would appreciate some advice ... thanks in advance

Jack

 

[bhicks11 via AccessMonster.com]

Try creating a macro that closes and opens the form. Call the macro on
closing the report.

Bonnie
http://www.dataplus-svc.com

 

[John Spencer]

That should work. I would double check the name of the form.

Closing a non-existent form does not generate an error, so if you misspelled
the form name or included an extra space you will get no notification that
there is a problem. Also, closing an existing form that is not open = no
error message.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County