VBA Userform Runtime Error 35788

[elind21]

Hi All,

I know this error has bee discussed before, but none of the solutions I have tries seemed to help.

I am running into the "Runtime Error 35788 An error occurred in a call to the Windows Date and Time Picker control." when I close my my UserForm. However, it only occurs if I have not used the spin control or the lookup text box to change the entry the form is pointing to. It also occurs on close if I use the "Write Entry" button and don't cycle to another entry.
I have tried:

Please Login or Register  to view this content.

in the close code to try and hide the error, but it still shows.

File in question is attached below, everything else works as intended. Form in question is on the "Data" worksheet, accessed by the big command button.

Thanks in advance for any advice,

Erik

[davesexcel]

It looks like you are calling "readField" macro when you are exiting the userform, but is that code not used to populate the userform controls?

[elind21]

How is it calling the readField sub on close?

[davesexcel]

You could go to the code that kicks in when you close the userform.
-
elind21.jpg

[torachan]

Replace > Private Sub txtDwgNo_Exit(ByVal Cancel As MSForms.ReturnBoolean) <
With > Private Sub txtDwgNo_AfterUpdate() <

[elind21]

Thanks torachan and davesexcel, that solved the problem. I didn't see the AfterUpdate() event in the list when I looked, must not have scrolled far enough.