Set Default Date in Datetimepicker using a query

[kbsudhir]

Hi All,

I am trying to set default date in the DateTimePicker using VBA in access 2007 on Win 7. But I am getting the below error:

Run-time error '2763'
DTPicker returned the error: An error occurred in a call to the Windows Date and Time Picker control

I am able to get the date sucessfully using the query. But not able to pass the same to the DTPicker. I have tried below codes but with same error.

TxtBox_Date.Value = rst!Event_Date 
DTPicker_EventDate.Value = TxtBox_Date

DTPicker_EventDate.Value = TxtBox_Date.Text

DTPicker_EventDate.Value = TxtBox_Date.value

DTPicker_EventDate.Value = rst!Event_Date

Please guide me on where am I going wrong and what should I do get this fixed.

Thanks for all your time and help.

Regards
Sudhir

 

[kbsudhir]

Its done guys.

The right code is:

DTPicker_EventDate.Value = rst!Event_Date

I was getting that error because my DTP was set in Visible = No mode as I was changing the mode after setting the default date. Now I changed it to visible before setting its default date.

Regards
Sudhir