Help w/ default expressions for a form 1

[Joel27]

In my database I have five forms for entering in the blue print numbers. These five forms are for the size of the prints being entered. A size prints, B size, C size, D size, and finally E size. These forms are gathering the data through a query I made. In each of these forms the print numbers are for the most part in numeric order.
Is it possible to make a default value expression that would put the next number in the new record?

Example:
PRINT #
-------
A30084
A30085
NEW* A30086 <-----&quot;Need an expression that would
do exactly that
-joel-

 

[ghubbell]

Check out Thread181-59887 and see if you'd like to use this idea instead. Text fields.....why's it always got to be text fields.... Gord
ghubbell@total.net

 

[Joel27]

I seem to be getting a #name? message in my form box
I used =Dmax([drawing number],[n:\log\drawlog])+1
and I did try =Dlast, for the heck of it all.

Any thoughts to whats my problem?

joel

 

[ghubbell]

Ya, like the post above says it doesn't fly with text fields which I guess you need 'cause of the &quot;A&quot;. I could give you another cool choice so this would work: Split your number. Keep your number a number but have a &quot;Prefix&quot; field just in front. (I do this here as a matter of fact, where quotations are prefixed by province.) Works really well, takes a minute to make a prefix table: prefixID, Prefix.
Then add prefixID as a foreign field to your drawing table. If this appeals to you, start it out and write back if you need help in clipping those &quot;A&quot;'s from your drawing numbers before switching them to numbers from text. Gord
ghubbell@total.net