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

Check out this post, see if it helps you any.

Thankyou verymuch for pointing. Let me give a try and revert back.

Respected nckdryr

I checked the post which you have mentioned.

http://www.dbforums.com/6276908-post34.html

Its great. Thank you very much for the same. I have some clarification on the same. The calendar control which is used in the above mentioned post is working great for Single Forms. But how do I reuse it for Continuous Forms. The problem is the size of the calendar control, which leaves long gaps between the forms. Is there a way where I can reuse with small modifications. I know that I can use a seperate form with the calendar control in it and then popup the same when required. But I feel that a having the calendar in the same form is aesthetically good.

Could you please help me with the same.

Thanks.