Default Value in form

[Madhup Thakur]

Access 2000 / Win 98

I wish to increment by "1" a default value in a form in a column. But I do
not wish it to be an Autonumber since I need it to be "Editable" on the fly.
Is there a way? Thank to anyone who would care to respond.

M. Thakur

 

[AlCamp]

Madhup,
I think you want to use the DefaultValue for a field to increment that
field.
(ex. field name [MyField]... use your own)
Try a DefaultValue for MyField of...
= DMax("[MyField]","tblMyTable") + 1
Since this is a DefaultValue, it will be editable.
Better make sure the field is defined in your table as NoDupes if you're
using it as a key field.
hth
Al Camp