How can I add the next consecutive letter?

[flower88]

Hello,

I have a database that tracks revisions. A new record gets assigned letter "A" but if you want to make changes to the same record, that would be a new revision so you need to write the letter "B".

I want the revision letter to be automaticaly assigned after I ask the user if they want to create a new revision. I created a true/false select case box or statement.

My problem is that I do not know how to add the next consecutive letter to my textbox. I am new at this, but I tried doing the following where "revision" is the name of my textbox:

me.revision= me.revision+1
---------
me.revision= chr$(revision)+1
------
me.revision=asc(revision)+1

Clearly, none of the 3 ways I wrote this worked. They just look wrong.

Can anyone help me?

Thanks!

[OldBirdman]

Me.revision = Chr(Asc(revision) + 1))

[NeoPa]

I assume you have a routine where you'd put this, but essentially the command is pretty much as OB has it :

Me.Revision = Chr(Asc(Me.Revision) + 1))

[flower88]

OldBirdman thanks a lot! It worked. I was so close, but not really lol,

thanks!