Why won't DateTimePicker work?

[Kevin]

I'm doing something like this:

With frmMain
.DTPicker1.Value = rs.Fields("MyDate").Value
.Textbox1.Text = "BlahBlah"
.ShowDialog()
End With

When the form appears, it has today's date in DTPicker1 instead of
what's in the data record. Data field is of type DateTime in SQL2000,
Date value is in the "Short Date" format.

[Claes Bergefall]

Have you turned on option exclicit and option strict?
Are you sure Value returns a DateTime object? (And what is the *exact* value
it returns)

What type is rs btw (I couldn't find anything related to db stuff with a
Fields property or method)?

/claes

"Kevin" <ke****@cfl.rr.comwrote in message
news:n6********************************@4ax.com...

I'm doing something like this:

With frmMain
.DTPicker1.Value = rs.Fields("MyDate").Value
.Textbox1.Text = "BlahBlah"
.ShowDialog()
End With

When the form appears, it has today's date in DTPicker1 instead of
what's in the data record. Data field is of type DateTime in SQL2000,
Date value is in the "Short Date" format.