Validation Question

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a field on my form which can't contain a null value (validation rule
is - is nut null)

I have a command button "submit" which runs a simple macro which is, Go to
new record, sets the focus to "Date from" and displays a message box.



When the validation rule is broken I get the validation message, but then I
get an information box that states "you can't go to the specified record" I
click ok and then get a box showing me the macro that has failed and I have
to click HALT



Can I set it up so that when the validation rule is broken I get the
validation rule text only and not the 2 boxes informing me that the macro
has failed

Also if possible after clicking ok on the validation text box, the focus
would go to the relevant field that the rule has been applied to.



Thanks for any help



Steve


.

Quantcast