Date Picker Control

[sakthivels]

Hello Greetings to everyone,

I am designing a form to collect the following:

C_Name : Text (50)
C_Add1 : Text (50)
C_Add2 : Text (50)
City: Text(50)
ZipCode : Text(15)
Join_Date : Date / Time

for collecting the Join_Date information I would like to use the Date picker control. I tried setting the Control Source of the Date Picker control to the Join_Date filed.

But the problem is that the field doesn't get updated in the table.
Could someone please advise me on using this control.

Thanks in advance,
Regards,
Sakthivel

 

[missinglinq]

Don't really know what to tell you. Setting the calendar's Control Source to the field in the table should work, although a more common approach is to have a texbox for Join_Date and then assign the date picked like this:

Private Sub DatePickerName_AfterUpdate()
 Me.Join_Date = Me.DatePickerName
End Sub

Only other thing I can think of is to delete the DatePicker and recreate it.