Validation rule question

[Guest]

Hello,

I have two questions on validation.First, is it possible to create a
validation on a amount field for a form that has already been created or
should i create it within the respective table?Reason:the database has been
in use for two weeks and i dont want a meltdown if i place a validation on
this field.
Second, the field is a dollar amt field and i would like that the user could
not enter an amount greater than 10,000 and when trying to do so , it would
open another form made for this amount so the 10,000 can be entered into
it.Is that possible?
Thanks

 

[Wayne Morgan]

A Validation Rule can be done more than one way. It can be done by placing
it in the table setup or by checking the value in code on the form before
saving the entry.

For what you're trying to do, the second way sounds better. In the control's
BeforeUpdate property you would check the value of the control and react
accordingly. You could pop-up a message box, cancel the update, open another
form, or just let it be if the value is ok.