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..
For Each ctrl As Control In Me.Controls("pnlMainPanel").Controls
If ctrl.GetType Is GetType(System.Windows.Forms.Panel) Then
For Each subCtrl As Control In ctrl.Controls
If subCtrl.GetType Is GetType(System.Windows.Forms.TextBox) Then
If subCtrl.GetType Is ...