Running Sum Effect on Form

D

David W

Is there a way to have a runningsum effect in a textbox to show the number
of the record that a query has returned?

For example if a query returned 5 records
1st record would equal 1
2nd record would equal 2
3rd record would equal 3
and so on.
 
M

Michel Walsh

Hi,

You have the result into a recordset? the recordset property
AbsolutePosition can be used.


Hoping it may help,
Vanderghast, Access MVP
 
K

kelly draper via AccessMonster.com

I've been wondering how to do the same thing that the original poster was
wondering about indicating on each record of a continuous form, in a
textbox, the record number of each record. I was looking into the
absoluteposition property but couldnt figure out how to use it to assign a
value to a textbox on a form. would it have to go into an event handler? an
expression in the control source? how does the record navigation bar know
what the record number of a record is.

thanks.
 
Top