I have a form (frmentry) for entering data into a table (tbldetails) and I want it to automatically check a surname taht is entered against the suranme field in another table (tblstruckoff) and then alert the user if there is a match.

I am presuming that htis would be done using an After Update event on the form field but I am a complete VB novice.

Any pointers or help would be greatly appreciated

Many thanks in anticipation,

Rob McCreedie

You'll have to use the before update event,try using DLookUp against the second table

I know i am going to sound like a complete newbie, but i have never used the Dlookup before is it straightforward???

Many thanks in anticipation,

rob