field Default Value equal to record number

[Guest]

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

 

[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
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Guest]

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".

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.

 

[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"