Rx_
Nothing In Moderation
- Local time
- Today, 02:38
- Joined
- Oct 22, 2009
- Messages
- 2,803
Remarking out the doCmd.Echo False solved the problem. Why does this happen?
Splash Screen - button --> Single Form with List box & several buttons --> Tab Form Pop-up with buttons --> single pop-up (code in close button)
Going backwards - the Single Form with List box & Several buttons totally locks up. Unless the docmd.Echo False is remarked out. Why?
A splash screen with a button opens a form with a list box and category buttons, that opens a specific pop-up form. This pop-up form opens a pop-up form for bulk update.
Now, this last pop-up form had the code in the cancel/close button
Private Sub cmdCancelUpdate_Click()
On Error Resume Next
'DoCmd.Echo False
DoCmd.Close
End Sub
Before the 'docmd.echo False was remarked out;
The last pop-up would close
The next to last pop-up would close when it's close button was selected.
The next form would be frozen. Nothing would respond. Closing Access was the only option.
Once the docmd.echo False was remarked out - every thing test perfect.
If the very last pop-up was closed with the X in the form upper right - (avoiding the docmd.echo) the failure did not happen either.
A little strange it was two levels down!
The docmd.echo false was from a copy paste - I didn't think it would hurt.
Splash Screen - button --> Single Form with List box & several buttons --> Tab Form Pop-up with buttons --> single pop-up (code in close button)
Going backwards - the Single Form with List box & Several buttons totally locks up. Unless the docmd.Echo False is remarked out. Why?
A splash screen with a button opens a form with a list box and category buttons, that opens a specific pop-up form. This pop-up form opens a pop-up form for bulk update.
Now, this last pop-up form had the code in the cancel/close button
Private Sub cmdCancelUpdate_Click()
On Error Resume Next
'DoCmd.Echo False
DoCmd.Close
End Sub
Before the 'docmd.echo False was remarked out;
The last pop-up would close
The next to last pop-up would close when it's close button was selected.
The next form would be frozen. Nothing would respond. Closing Access was the only option.
Once the docmd.echo False was remarked out - every thing test perfect.
If the very last pop-up was closed with the X in the form upper right - (avoiding the docmd.echo) the failure did not happen either.
A little strange it was two levels down!
The docmd.echo false was from a copy paste - I didn't think it would hurt.