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.

 

[awiezzz]

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