Message warning existant record

E

Emanuel Violante

Hi,

I'm using a costumer form.

Client_name field can be duplicate but I would like an alert message to
pop-up saying that the same client name allready exists.

Sorry if the english is not correct, I hope you understand what I need.
 
K

kerry_ja

I would have code in the after update event for that field. Use DCount
to see if that client name already exists, and if so have a message box
stating that
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DLookup duplicate question 3
Dlookup help for duplicate phone number entry and message box. 8
Searching Across Two Tables For A Record 3
Open Message when no record found 1
if duplicate goto record 3
Check if an external file exists 3
A On Open problem 5
two forms, same table 5

Top