Default value in text box

[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

 

[Software-Matters]

Hi Josh,
Try putting your code in to the Control Source of the text box, not the
Default Value.

Regards
JD
--
<a
href="http://www.software-matters.co.uk/bespoke-database-design.html">Bespoke
Access Database Development</a>
<p>Software Matters</br>
Straightforward solutions that work</p>

 

[John W. Vinson]

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

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?