I have a form with two text fields with dates to select
the first on is a "from Date" and the second is a "To Date"
I have the following code used to pass a parameter
to check if the from Date is > To Date then the msgbox will come up
this is for when I change the dates
in cmdEdit_onclick
Code:
If Me.txtFromDate > Me.txtToDate Then
MsgBox "'Between Dated' must be more than Start Date!", vbExclamation
Exit Sub
Else
I Use the Same Code in the cmdAdd and it works fine
I have also had it working in the past. I am not sure why it changed.