Add a new field to a datasheet view

[Guest]

Hi there,
I have a sub form (datasheet view) which has an unbounded field. I would
like this field to display the record number for each record being displayed
within the datasheet. Is this possible and how could I do it? I can perhaps
can calculate the number of record but I do not know how to display it for
each reacord. Any idea is greatly appreciated in advance.

 

[Arvin Meyer [MVP]]

An unbound field would have the same value in every row. To display a record
number, you must have the field bound to a record number row in the
underlying table. That record number will not change due to changes in the
subform's recordset.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks, I got it.

An unbound field would have the same value in every row. To display a record
number, you must have the field bound to a record number row in the
underlying table. That record number will not change due to changes in the
subform's recordset.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access