ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Why is this code not working (https://www.excelbanter.com/excel-programming/428211-why-code-not-working.html)

Ayo

Why is this code not working
 
I am using the code below on a command button on a form but the form just
blinks and nothing else happens.
Private Sub cmdCancel_Click()
Unload Me
MilestoneForm.Show
End Sub

This is a similar code I used in another file and this works perfect.
Private Sub cmdCancel_Click()
Unload Me
ufrmsiteInfo.Show
End Sub

Any ideas what is going on where?
Thanks

Nigel[_2_]

Why is this code not working
 
Is the name of the form you are closing MilestoneForm ? As you are
re-initializing if it is.

--

Regards,
Nigel




"Ayo" wrote in message
...
I am using the code below on a command button on a form but the form just
blinks and nothing else happens.
Private Sub cmdCancel_Click()
Unload Me
MilestoneForm.Show
End Sub

This is a similar code I used in another file and this works perfect.
Private Sub cmdCancel_Click()
Unload Me
ufrmsiteInfo.Show
End Sub

Any ideas what is going on where?
Thanks



Ayo

Why is this code not working
 
Thanks Nigel. I just figured out that I was unload the form and showing at
the same time. MilestoneForm is the same form that is being Unload.Me

"Nigel" wrote:

Is the name of the form you are closing MilestoneForm ? As you are
re-initializing if it is.

--

Regards,
Nigel




"Ayo" wrote in message
...
I am using the code below on a command button on a form but the form just
blinks and nothing else happens.
Private Sub cmdCancel_Click()
Unload Me
MilestoneForm.Show
End Sub

This is a similar code I used in another file and this works perfect.
Private Sub cmdCancel_Click()
Unload Me
ufrmsiteInfo.Show
End Sub

Any ideas what is going on where?
Thanks





All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com