BeforeUpdate compare two fields on same record

[blacknblue]

Hello,

I'm trying to prevent an update to a record if a three digit code in the center of a compressor model number does not match the first digit of a unit model number.

For example:



Unit model number F054VHN = Compressor model number ZP103KCE-TF5-455

I've attached my database. Thank you very much in advance.

[rpeare]

I can't read 2007+ databases.

If you are checking a specific character for a specific value you can use the MID function

So let's say on your form:

MODELNUMBER is your F054VHN
COMPRESSORMODEL is ZP103KCE-TF5-455

if you are trying to see if the 11th character of COMPRESSORMODEL is equal to the first character of the MODELNUMBER

you would have to set up something in the BEFORE UPDATE event something like

if left([MODELNUMBER],1) <> mid([COMPRESSORMODEL],11,1) THEN
    Msgbox "Model Number Mismatch"
endif

[Missinglinq]

...if a three digit code in the center of a compressor model number does not match the first digit of a unit model number.

How can a three digit code ever match a single digit?