Add letter to incrementing number? 1

[needadvice]

I have the following code that increments to the next number each time a form is opened:

X = DMax("[REF#]", "OrderTBL")
X = X + 1
Me.[Ref#] = X


Is there any way to add the prefix "E" to the number so it come out like E1,E2 etc.. I concatenated it but that only worked once, then the next number would not generate. I finally just made it two seperate fields but am curious to know if there is a way.
Thanks for any help.

 

[SkipVought]

Hi,

X = DMax("[REF#]", "OrderTBL")
X = X + 1
Me.[Ref#] = "E" & X

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[PHV]

Me.[Ref#] = "E" & (1 + Val(Mid(Nz(DMax("[REF#]", "OrderTBL", "[REF#] Like 'E#*'"), "E0"), 2)))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[needadvice]

PHV that worked just right,
Thanks