Warn user if Duplicate Exists

[mwheads]

Hi All

I have got a BANKACCOUNT field that I don't want to make a indexed field but I want to warn the user with a messagebox (on exit of the BANKACCOUNT textbox) that the field exists for CONTRACTOR or list thereof.
The user could then choose to use the existing record with a CASE Y/N or see if the other is adequate.

Anybody familiar with this or a more efficient way?

*The BANKACCOUNT must support Duplicates.

 

[PHV]

You may take a look at the DLookUp function.

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