Default Value in form

  • Thread starter Thread starter Madhup Thakur
  • Start date Start date
M

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
 
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
 
Back
Top