Close form and reopen hidden ?? 
Author Message
 Close form and reopen hidden ??

Hi group,

I have an Autoexec macro opening a CustParm form, in hidden mode, to make
the data available trgrough the app.

Question :
as the user open this CustParam form, modify some data and then close it,
HOW to re-run the macro to have it open again and hidden ??

I have tried in the OnDeactivate in frmCustParam
doCmd.runMacro "Autoexec"
but anyway, after the macro re-open this form, it close it again.

Any idea should be more than welcome.



Sun, 18 Sep 2005 21:35:05 GMT  
 Close form and reopen hidden ??
Instead of letting the user close the form, just provide a close button
which sets the visible property false so that it is hidden rather than
closed.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Quote:

> Hi group,

> I have an Autoexec macro opening a CustParm form, in hidden mode, to
> make the data available trgrough the app.

> Question :
> as the user open this CustParam form, modify some data and then close
> it, HOW to re-run the macro to have it open again and hidden ??

> I have tried in the OnDeactivate in frmCustParam
> doCmd.runMacro "Autoexec"
> but anyway, after the macro re-open this form, it close it again.

> Any idea should be more than welcome.



Sun, 18 Sep 2005 22:06:52 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Closing a form when other form is opening but reopening when all forms closed

2. Reopening a form from the forms on close event

3. reload form without closing and reopening the form

4. Command to Close and Reopen Sub Form

5. Data will not update unless I close form and reopen

6. Data will not update unless I close form and reopen

7. form property values lost after close/reopen

8. RecordsetClone suddently stops working until the form is closed and reopened

9. form property values lost after close/reopen

10. Data will not update unless I close form and reopen


 
Powered by phpBB® Forum Software © phpBB Group