field Default Value equal to record number

  • Thread starter Default Value equal to record number
  • Start date
D

Default Value equal to record number

How can I make a field Default Value equal to the record number ?
 
J

Jeff Boyce

Isn't the record number already available? Why do you want to set the
default value of a(nother) field to record number?

Or are you saying you want to have a field that has the number that shows up
down in the navigation area? If so, be aware that that is ONLY a way to
count how many records there are -- those numbers are NOT attached to the
records. You can prove this to yourself by adding a record that fits
somewhere in the "middle" of the sort order and re-checking.

Does your underlying table have a Primary Key field? If you use an Access
Autonumber field as a primary key, that will hold a "record number".

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


"Default Value equal to record number" <Default Value equal to record
[email protected]> wrote in message
news:[email protected]...
 
D

Default Value equal to record number

Jeff Boyce said:
Isn't the record number already available? Why do you want to set the
default value of a(nother) field to record number?
down in the navigation area? If so, be aware that that is ONLY a way to
count how many records there are -- those numbers are NOT attached to the
records. You can prove this to yourself by adding a record that fits
somewhere in the "middle" of the sort order and re-checking.
Does your underlying table have a Primary Key field? If you use an Access
Autonumber field as a primary key, that will hold a "record number".
Click to expand...

Dear Jeff,
I have good reasons for my question but you did not answer the question.
Maybe this proves that it is not possible at all it seems.
Thanks.
Guido.
 
J

Jeff Boyce

Unless I have a clearer idea of what you are trying to accomplish, I can
only speculate. I didn't answer your question because I didn't understand
enough about what you are trying to do. No disrespect intended...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/



"Default Value equal to record number"
 
Top