Incrementing a textbox on a continuous form

[ultimateguy]

I have a continuous form and I want to have a text box or a label next to each record that simply shows the Record Number. I have tried using a text box with Control Source = [Current Record]. This works for the Single Form view but when I change to continuous form, they all show a value of 1.

How can I accomplish this?

[June7]

Not easy in query or on form. Review http://allenbrowne.com/ranking.html

Textbox on report has a RunningSum property which allows this.

Why is this needed? What purpose does this serve?

[ultimateguy]

The only purpose is to be a visual guide for the user. The form shows a round of trivia questions and I just thought it would be nice to show the question numbers. It's not essential however.

[ranman256]

You could start with a empty table that has an autonumber field (name this as tTriviaMT)
copy the tTriviaMT to tTrivia
load tTrivia with the questions. The autonumber will number the questions 1 thru X.

Each time you load a new set of trivia, you have to start with the empty tTriviaMT table copy, so autonumber will start with 1.

[ultimateguy]

I have thought of doing that, but I would need to make a new table each time so that the AutoNumber restarts (because if I erase the table and populate it with a new round of ten questions, the AutoNumber will be from 11 to 20). I have been told previously by June7 that code that modifies the structure of the database should be avoided.

[June7]

Don't delete table, delete records. Instead of autonumber, use code to populate the field with a sequential value.

There is a way to generate a sequential number using DCount but this requires another field with value that will sort the records in an ascending order. Not very practical in reality.

[NoellaG]

Hi,

in the included example you'll find 2 ways to include a counter:
- with a domain function: when you close the form it counts on from the last max number
- with a form property: each time you close the form the counter restarts from 1

greetings
NG