I know you have used the dtPicker to select a date. You must still do something with the returned value though. I have found that by calling the value when using a database tends to screw up from time to time, hence the text box value. You can also add the value to a variable -
Dim xDate As Date 'At the top of your code form
'Under your dtPicker_Click event
xDate = dtPicker.Value.
'Now use the code above to add the date to your table.
Have a look at your "ADODC" post, I gave a full on tutorial there.
Daclare a variable for the date at the TOP of your form -
Dim xDate As Date
Private sub Command1_Click()
'All text boxes has been cleared...
xDate = dtPicker1.Value
'This will hold the variable until you clear it.
'After adding new record, use...
xDate = vbnullstring
i said that when a button is pressed, the dtpicker should show system date, which date is stored in my computer, dtpicker should show that one, then it should b user's choice,which one he is selecting..