Record Selector number

[Rog]

When I run a query I see the record selector at the
bottom left of the screen. The number in the 'record
selector box' shows which record/row the cursor is on.

How can I get that record/row number to display right on
the row?

Thanks.
Rog H.

 

[Allen Browne]

There is no *efficient* way to do this in a query. Essentially you have to
use a subquery or DCount() to count the number of previous records.

It's very easy in a report: Just add a text box with these properties:
ControlSource =1
Running Sum Over All

In a form, you can achieve the same result with this code:
http://www.lebans.com/rownumber.htm