By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 853 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Default field value = record number - How do?

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
Thanks for the help!
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.