After Update

[mcreedie]

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

 

[Rich]

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

 

[mcreedie]

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