Date Validation in Forms and subforms!

[Arrrggggjhhhhh!!!!]

Can anyone help?

I am trying to create a form where the date in the subform, called
Date Attended, cannot be earlier than the Employment Date in the main form.

(Date Attended is a sub form contained within the main form. The main part of the form has a field called Employment date.)

I think the way to do this is to use the before update box in the event area of the properties of the Date Attended field. The thing is, when I put validation in the expression builder it does not work.



I suspect some sort of IF statement may be required.

Surely this is not that complex a job???

Does anyone have any thoughts or tips regarding how to do this???

Thanks

Arrrggggjhhhhhhh!!

[June7]

Show your code for analysis.

Could try the Validation Rule property of the textbox.

>= Forms![mainformname]![Employment Date] Or Is Null

[Arrrggggjhhhhh!!!!]

Nice one.

I tried it and it worked.
I've been trying for days to get this to work in all sorts of ways so this is a result.
I think I was looking for something more complicated than it was (e.g. IF statements etc)

Thanks

[June7]

The Validation Rule property won't work for all situations but should serve for most. Sometimes VBA will be needed.