Hi. I have a primary key field called VendorID. It is variable-sized text field.
I have a filed called Vendor that is supposed to be the Vendor name minus the 2-digit suffix given at VendorID.

How do I word the after Update of VendorID so that Vendor is the same, but minus the last 2 digits?

Russ

Dim vLengthOfString

vLengthOfString = Len(VenderID)-2
Me![Vendor] = Left[VenderID, vLengthOfString)

Thank you! Thank you! Thank you!

I can't tell how (out of embarassment) how much time I have spent on this.

Russ