I've a little concern about Validation rule on date/time field on form:
I'm using Validation rule " Between #01-Apr-12# And #31-Mar-13# " on Challan_date field and it's working fine while entering manual entry but when someone uses calender control, it doesn't work at all. It accepts any date set through Calender control.
My concern is to restrict user to enter date between the criteria set.
Calender Control code:
Private Sub cmdCalendar_Click()
Set ctlIn = Me.Controls("Challan_date")