Textbox Validation - only allowed a date + BeforeUpdate

[Ian Mac]

All,

I'm trying to get the correct syntax to Validate a Textbox.
I'm trying to use BeforeUpdate bet can't figure out the how.

Rules:

Person must enter a Date:
>=#09-11-04# and <=Date()

The problem I have is that I need to run some code to update 3 other Fields on the form, If the above is true.

BUT! how do I stop someone entering 'Ian' or % or whatever and trap it
It seems that the 'Short Date' format validation kicks in before the BeforeUpdate event. Or stops it, or something.

I'm a little confused and could do with some help,

 

[SydneyGeek]

Ian, I think you can do this using the BeforeUpdate event of the FORM, not the textbox. That way, the user can put the crummy data in but can't go to the next record without fixing it. [You can also enter code to set focus on the offending textbox]. In the same event code, you can update the other fields too.

Does that help?

Denis