Re: Simple DTPicker Question
1 Yes on form_load
2:
VB Code:
Private Sub DTPicker1_Change()
If DTPicker1 > DTPicker2 Then DTPicker1 = DTPicker2
End Sub
Private Sub DTPicker2_Change()
If DTPicker1 > DTPicker2 Then DTPicker1 = DTPicker2
End Sub
Re: Simple DTPicker Question
Hi oh1mie,
1) yes to u can put a now date as a value under the DTPicker property? if yes, may i know where?
If yes by putting under the form event, but whenever a click a new record, it was give a different value e.g. 12/5/05.
2) Sorry, maybe my question isn't clear enough. I like to do a validation on the dates. Date1 is a fixed now date. Therefore date2 cannot be set less than Date1, if yes... prompt a error message to ask user to reenter.
This condition applies to date3 too.
Re: Simple DTPicker Question
Right place is Form_Load event
VB Code:
Private Sub Form_Load()
DTPicker1 = Now
End Sub
Question 2
VB Code:
Private Sub DTPicker2_Change()
If DTPicker2 < DTPicker1 Then DTPicker2 = DTPicker1
End Sub