Validation ISSUE

[Steve5]

Validation ISSUE

I enter a 5 digit number "12345"

 into a form linked to a table.[T_Station_1] Then I need to validate the number does not exist in an another table [T_Station_V] which are my voided numbers. 

Now I have been trying this in a macro set at after Update. With a MSG pop-up stating it is a VOIDED number – then I have a [SelectRecord] then [DeleteRecord] from table and allow user to continue.

But it just does not seem to work? 

I am familiar with VB, but I am better with Macro’s. please help…

 

[WayneRyan]

Steve,

If Not IsNull(DLookUp("[SomeCode]", "T_Station_V", "[SomeCode] = '" & Me.Code & "'")) Then
   MsgBox("Hey! It's there already.")
End If

Wayne