form validation

[AFKAFB]

hi
i've entered the following validation rule
>=1 and <=5
with a message saying blah blah blah
the message box was being shown earlier but now its not being shown but the data validation is working.
its like i've turned off the messages but i cannot see how.
regards
chris

 

[PHV]

Have you created an Error event procedure in your Form ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AFKAFB]

hi
no
would this help
and if so what should i write to ascertain why the validation message boxes are not showing
chris

 

[PHV]

would this help
no
Have you played with SetWarnings ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AFKAFB]

i think so
how would i know if they are turned off

 

[PHV]

In the debug window (Ctrl+G) type the following:
DoCmd.SetWarnings True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AFKAFB]

still not showing the message box