Running Sum Effect on Form

  • Thread starter Thread starter David W
  • Start date Start date
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.
 
Hi,

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


Hoping it may help,
Vanderghast, Access MVP
 
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.
 
Back
Top