Recent content by abtibs

JR, That worked great, thanks! I can see where this is going to be extremely useful for me. I assume the same can be done for RecID? I may have non-numeric data there as well. Update: I got it, just had to change RecID As Long to RecID As String Thank you very much JR!

Thanks for the responce JR. The reason I asked is because I ran the sample DB and it worked great until I input "text" (A,B,C) in the table. It appears that all the values need to be numeric.

Can this code be used for text fields as well as number?