Saving DTPicker settings in Userform

[jerrydiaz]

Hi--

I hope somoene can help me with this. I just cannot figure out how to get this to work. I want to have a Userform retain the last date that was selected in a DTPicker control but no matter what I try, it keeps defaulting to today's date.

The form opens specified files based on Region, Report Name and Date. So, for example - today is 10/17 amd I am pulling reports for the week ending 10/12:

1.I select 10/12 with the DatePicker, click my OK button and it opens the correct file.
2.I "Exit" the form (using the Exit button for which the code is posted above), do what I need to do with the file and close it.
3.Then when I invoke the form to open the next file, the date in the DatePicker defaults back to today's date rather than 10/12 remaining selected.




The Exit button has the following code:

Please Login or Register  to view this content.

and the form Initialize code is:

Please Login or Register  to view this content.

Can anyone please offer any guidance?

[jerrydiaz]

Sooo, anybody?