VB6 Calandar linking to Access 2000 DB

[ChrisN0123]

Hi,

I am trying to link the calendar to an access
database to switch fields in the database.

Eg. I click on 1st June 2003 and it will change
to the record line in the database.

The calendar does move by date/day if you move the
field in access, but doesnt do it if you click on the
relevant date on the calendar.

All I need is the code the the Calendar1_Click().

The database field is named "DayView" and the database
control is Adodc1.

Any help would be greatly appreciated!!

Regards,
Chris N