Default field value = record number - How do?

[Irwinsp]

Hi All,
I have a subform where the user can enter data. I would like a field to
default to the record number. How can I do this? (It can not be an auto
number field for other reasons.). Thanks.
Paula Irwin

[Wayne Morgan]

Record number of which recordset? A subform usually has a subset of the records of its
record source because it is filtered by data on the main form. Do you want to create a
field with consecutive numbers for the table that the subform data comes from?

If so, for the DefaultValue of the control, try

=DMax("[FieldName]","TableName")+1

--
Wayne Morgan
"Irwinsp" <ir*****@aol.com> wrote in message
news:20***************************@mb-m19.aol.com...

Hi All,
I have a subform where the user can enter data. I would like a field to
default to the record number. How can I do this? (It can not be an auto
number field for other reasons.). Thanks.
Paula Irwin

[Irwinsp]

Thanks for the help!