Verify 1 Field Against Another For Duplication Follow
I have 2 serial labels that are manually entered by the user for our packaging needs. I'm trying to detect when they might accidentally duplicate the serial on the label accidentally.
I tried to use the OnProcessData command as shown in the code below on SERIAL 2 field but what I'm finding is that when trying to verify the data against SERIAL 1 field it's pulling the value that was on the label prior to the user prompt. Also, when I put something in the Else part of the clause i noticed that this OnProcessData procedure gets called A LOT when modifying or printing.
Anyone have ideas to help please??
aString = Value
bString = Format.NamedSubStrings("Serial1")
If aString = Format.NamedSubStrings("Serial1") Then
MsgBox ("DUPLICATE" )
Please sign in to leave a comment.