How to display running number in form?

[awiezzz]

Hi,
I have many records in 1 form, is it possible for me to display running number on that form? I can display running number in report by putting textbox and set its control source to =1. Is it possible to do that in form?

any idea? thanx in advance..

 

[RuralGuy]

Try looking here:

http://www.lebans.com/rownumber.htm

 

[mresann]

I would number the records on the underlying query (call the field RunCount), then refer to RunCount on the form.

If you need to see a sample, check out the tutorial I wrote for subforms here.

 

[Pat Hartman]

Running sums or record numbers in forms/queries are difficult to perform due to the nebulous nature of record order which can be easily changed. These calculations are typically performed with DSum()s or code that runs queries. In either event, they tend to be quite slow once your recordset exceeds a few hundred records. They also require a unique ID and the recordset must be sorted on that ID for the running sum to make sense.

A balance is quite different. It can be handled with a simple aggregate function in the form's footer and it will not slow down the operation of the form so unless you really need to see a balance forward on each record, the ending balance in the footer will be a better choice.

 

[awiezzz]

Hi all,
thanx for reply..
i've tested the code and it works..thanx again..