Default value in text box

  • Thread starter Thread starter jamccarley
  • Start date Start date
J

jamccarley

I made a text box with the default value of = "SVR" & [NumberID]. This shows
a value of "SVR57001" on my first record, but when I add new records, it
stays at this value. Why is the number not increasing as the NumberID
increases?

Josh
 
I made a text box with the default value of = "SVR" & [NumberID]. This shows
a value of "SVR57001" on my first record, but when I add new records, it
stays at this value. Why is the number not increasing as the NumberID
increases?

Josh
Click to expand...

What's the datatype of NumberID? If it's Autonumber it will increment
automatically (and will have gaps, and can even become random, and probably
should not be displayed to the user at all); if it's a Number field you'll
need *some* sort of code to cause it to increment. Do you have such code
elsewhere?
 
Back
Top