create a button which displays the next available preformatted num

  • Thread starter Thread starter Arlene
  • Start date Start date
A

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.
 
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!
 
Arlene said:
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!
Click to expand...

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

MsgBox Me.TutorID + 1
 
Back
Top