The userform doesn't seem to unload although I am using unload me line.

[aman1234]

Now when the userform UF1MadHatter gets uploaded then a message is displayed "This Application is for Editing and Exiting Batches in the MI only.Do you wish to continue or not". If users press Yes then FrmDate gets displayed otherwise application is closed.

When the users press SAVE button on the UF1MadHatter form then data gets updated in the table. But the userform UF1MadHatter still appears on the screen and upon that userform again message appears "This Application is for Editing and Exiting Batches in the MI only.Do you wish to continue or not". If users press Yes then FrmDate gets displayed upon the other form but in actual I want to unload the userform UF1MadHatter when the user press Save button and the message should display.

I have written unload me and UF1Madhatter.show lines on the SAVE button but it doesn't seem to work. Any help would be much appreciated.

Workbook open event, following code is written.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The following code is written in UF1MadHatter Save button.

Please Login or Register  to view this content.

[romperstomper]

I assume the second code is actually in FrmDate since otherwise you're just unloading and reloading the same form?

[aman1234]

Romperstomper, The second code is also in the same form. The thing is when workbook gets opened then the userform UF1MadHatter gets displayed. When its Save button is clicked then I want to it initialze the same way it gets intialized when the workbook is opened but its not doing that way. I am not sure what is causing the problem?

Thanks

[romperstomper]

Try replacing this:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

[aman1234]

Thanks romperstomper. Call userform_Intialize worked. But still on some textboxes i get error message like "can't move focus to control because its either invisible,not enabled" etc..

When the workbook is opened then this userform gets loaded fine and i am able to type values in all the textboxes. But then when i press SAVE then with the use of call userform_Initialize , it gets loaded fine but i can't type values in all of the textboxes as i get that error message in some of them. So why it works fine the very first time it gets intialized and after clicking on save button , it doesn't.

i hope you can help me in this.

Regards,

[romperstomper]

Which line gives you the error?