E
Eileen
Guest
I need to check a number field for duplicate values in previous records on exit of the field. I think this has to be done using a DLookup otherwise the unique value property does not kick in till the user tries to save the record, and the error message means nothing to the user.
Can anyone tell me how to put together this Dlookup, and anything else I have to do? My field is called [RefNo] and the table is [Call Details Table].
Please help
Eileen
Can anyone tell me how to put together this Dlookup, and anything else I have to do? My field is called [RefNo] and the table is [Call Details Table].
Please help
Eileen