Form Field Validation

[dhav79]

Hey guys,



I have an access form with 8 fields that require a date range validation.

ex.

PlanningA Start Date
PlanningB End Date

PlanningC Start Date
PlanningD End Date

PlanningE Start Date
PlanningF End Date

etc..


I need the Start Date to be <= to the End date, if the user does not enter it correctly, I need a msgbox to display "PlanningA Start date should be less then PlanningB End Date". I've found some vb codes, but haven't gotten them to work.

Please help.

[pbaldy]

I'd use the before update event of the form:

http://www.baldyweb.com/BeforeUpdate.htm

You would simply test one date against the other.

[dhav79]

Thanks for the quick reply, but i dont think that solves my issue. I need something that does the following:

if
(PlanningA Start Date > PlanningB End Date)
then
msgbox="Start does has to be less then the End date ex. 02-02-2009 Start - 01-01-2010 End."


So therefore, if the the date range is correct, move onto the next field.

Remember we are validating between two fields at a time, ex. PlanningA Start Date to PlanningB End Date.

Love to hear more suggestions.

[pbaldy]

Like I said:

You would simply test one date against the other.

You've basically typed it all out yourself. The code would look like:

If Me.StartDateField > Me.EndDateField Then
  msgbox "Start does has to be less then the End date ex. 02-02-2009 Start  - 01-01-2010 End."
  'Do whatever you want here
End If