Multi-Page Form issue with DTPicker

[cleverku]

Hi,

I have a problem with a multi-page Form (the one with multiple tabs).

On one page of the multi-page form I have a DTPicker (Windows Date and Time Picker).

When I am on a different page, I run code which may change the date value that is selected on the DTPicker.

The problem I am having is that if I am not on the page where the DTPicker is when my code is trying to update it, I get a run time error

Run Time Error '35788': An error occurred in a call to the Windows Date and Time Picker control

A messy way around this I have used is to have my code select the page where the DTPicker is located before changing it's value, and then going back to the original page, but then I get a really messy looking page flicking which I can't have.

What is a good solution around this. I'd be happy with either a way to avoid the error, or just stick with flicking accross page, but then have some kind of ScreenUpdating = False that would apply to the pages so that the user doesn't see the flicking.

Any help really appreciated.

Chris

 

[Legacy 98055]

The first thing I would do is declare a module level variable in your userform to hold a reference to the instance of your dp. I would also try the Controls collection of the multipage page that parents it.