One more question for today, lol.
I have an unbound textbox (txt_SureyNum) that allows users to type in a number. The field next to this number (Survey_Num) concatenates the number with some text. E.g. user types in "6" and the box next to it becomes "TR6". This Survey_Num actually gets entered into the table.
Now when cycling back and forth through records the unbound textbox will always contain what was last typed in, e.g. it will always be 6 even though when the record was created it was originally 4.
This could really screw things up. :(
So I am trying to figure out how to get the unbound textbox to display what was originally typed in for that record when the user scrolls through existing records. I thought it would be easiest to take the concatenated field (Survey_Num) and un-concatenate it so to speak. That is, trim off the left two letters and leave the number.
But I can't find the function! I can't use just Right() because the number of digits I need will change (e.g. TR3 vs TR13). And LTrim only trims a string, not the number of characters to be removed. Unless I'm missing something? Is there another function to look at?
Or a better way to do this all together?