Customise Access Error Messages?

[Stephen Glynn]

I'm trying to design a data-entry form that includes a 'log number'.
This is assigned by the operator. It's required and it must be unique.

I've dealt with the requirements by making it indexed (no duplicates) in
the table. However, I don't much like the very general error message
this results in. Is there a way to change the error message for this
particular field or is there another way that I can make sure I don't
end up with duplicate log numbers?

Steve

 

[freakazeud]

Hi,
do the validation at form level. That way you can customize the error as you
wish.
Check this tutorial for a step by step example:
http://www.databasedev.co.uk/duplicates.html
HTH
Good luck

 

[Stephen Glynn]

Thanks. That looks exactly what I need.

Steve