Validating a Field

[abby_1309]

I have 3 dates Field "M11Qdate","DateSubmitted","DateDue"
I want to apply Validation On It
1)Cannot Left "DateSubmitted" Blank (user should not be able to go to next Control until there is a Date in "DateSubmitted"
2)"DateSubmitted" Cannt be less then "M11Qdate"
3)"DateDue" cant be greater then "DateSubmitted"

 

[wiremonkey22]

You can use some if .. then.. else....statements or select case like

cannot leave blank
if isnull(me.DateSubmitted) then
'do something here like a message box or undo set focus etc...'
else
'do this'
end if

Greater less than
if me.DateSubmitted > me.M11Qdate then
'do something here'
else
'do this'
end if

not a solution i dont know what your field names are just guessing read up on the if and select case syntax its what i use.

post some code you have tried some one can help you fix it.