Record Selector number

  • Thread starter Thread starter Rog
  • Start date Start date
R

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.
 
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
 
Back
Top