create a button which displays the next available preformatted num

[Arlene]

Hi again,

I want to be able to create a button that will check the TutorID in a form
and display the next unused ID that can be assigned to a new Tutor record.
This number is formatted in a special way, the format of the TutorID is:

first 4 numbers are fixed "1000"
and the next 3 numbers anywhere between 001 and 999

ex. 1000001 through 1000999

Thank you in advance for your help.

 

[Arvin Meyer [MVP]]

MsgBox Me.TutorID = 1

 

[Arlene]

thank you again, I was able to figure it out myself yey!, But I tried your
suggestion anyway thinking maybe that's the simplest way to do it but it
didnt work out for me .. but that's ok, thanks again for your time =) I
really appreciate your help!

 

[Arvin Meyer [MVP]]

thank you again, I was able to figure it out myself yey!, But I tried your
suggestion anyway thinking maybe that's the simplest way to do it but it
didnt work out for me .. but that's ok, thanks again for your time =) I
really appreciate your help!

That's because I must have missed the shift key. It should have been:

MsgBox Me.TutorID + 1