date criteria

[love2waltz]

I would like my form to only accept a date from the current date back to only 90 days in the past. The field name is ProcessDate. I am using a short date in this field. Is there some code I can use to restrict the date to the last 90 days? As always, I appriecate your help, thank you.

[rpeare]

you can set up a validation rule

>=Date()-90 And <=Date()

Then populate the validation text with whatever message you want

that's probably the simplest way

[love2waltz]

This works great thank you so much....one more question though, how do I turn off the automatic error message. Once the validation text message displays, a system generated message displays. I appreciate your help once again.

[June7]

Should not get a second message. I don't. Did not nothing special to prevent. Only set the ValidationText property.