Warning Message for Duplicate Entry

[Greycom4]

I have struggled with this for so long now I hope someone can help.
I have a form called frm_Collections which is run from the query (qry_Collections). When I type into the Reg field in the Form I would
like the user to know if the Reg details have already been used in a
previous record. The database can have duplicates in this field, however a
"Warning Message" would promt some investigation.
I have tried loads of DLookup on Before Update, but really need setting of
in the right direction.
Thanks

 

[battenberg]

http://www.databasedev.co.uk/duplicates.html

 

[Greycom4]

Thanks for that. I eventually managed to get it working.

 

[janeyg]

Hi, I have been struggling with this one to. Please can you share your solution?
Many thanks