Either the Dlookup() or DCount() functions as the next post shows.

ridgerunner wrote:
Can you please explain "Domain Function".

Usually verification code is placed in the BeforeUpdate event of a control
using a Domain function to look for duplicates.
[quoted text clipped - 16 lines]
tia
ridgerunner

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200805/1