View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Date Picker on Multipage

If the page is activated
Me.DTPicker1.Value = Date

If not try on change event...
Private Sub MultiPage1_Change()
If MultiPage1.SelectedItem.Caption = "Page2" Then
Me.MultiPage1.Pages(1).DTPicker1.Value = Date
End If
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Shawn" wrote:

Sorry needed to correct first post

How do I access a Date picker on a Multipage?
I want to assign it a value.
I have tried

frmTMF.MultiPage1.DTPickerReviewDate.Value = Date
and
frmTMF.DTPickerReviewDate.Value = Date

first returns error 438 - Object doesn't support this property or method
second returns error 35788 - An error occured in a call to the windows date
and time picker control