Simple DTPicker Question

[macky^^]

Hi all,

1) Can I set a now date for DTPicker value on the properties colunm?
If no, cani have put DTpicker.value = now under the form_load event?

2) What is the best approach to valid if the date1 cannot be less than date2.
Is the below coding good enough or there is a better way.

If DTpicker1 > DTpicker2 Then
MsgBox" You have enter an invalid date" & vbCrLf & "Please try again" , vbinformation, "Invalid Date"
Cancel = true
Exit sub
End if
 
If DTpicker2 > DTpicker3 Then
MsgBox" You have enter an invalid date" & vbCrLf & "Please try again" , vbinformation, "Invalid Date"
Cancel = true
Exit sub
End if