Increment textbox for Each Record (1 Viewer)

I have a form that I need to increment a textbox for each record in the table.

I have a table that lists problems that arise during production, and I just need to give them a number on the form via an unbound textbox. It seems like a very simple operation, but I can't figure it out! Maybe I am just thinking about it too hard

For Example, if there were 2 problems, I want my output to look like this.

Number Cause
1 Broken Gasket
2 Busted Shaft


If there were 3 problems, I'd like it to look like this:

Number Cause
1 Slimy Gear
2 Ran outta Oil
3 Forgot to turn on the power


Thanks!

cant you use a recordset to find the number of records in a table using Count()
then increment this value. alternatively use a combo box that has a MAX statement as a row source then just reference this value and increment it?

How exactly would I set my unbound txtbox to do that? If I use =Count, it gives me the total count of the records. I want it to number each one in order (Ex: 1,2,3). =Count() shows (Ex: 3,3,3).

Maybe I am not understanding what to do.

is it just the number yout need to increment?

say you had 15 rows in the table, you'd want the textbox to show 16?

why not use =Count+1

i suppose you could open a recordset and loop through gathering the names and adding them to a string. then just add the string to the textbox.

I have the textbox in the Details section of the continuous form. I want it to show what number record that is. I just need it to put a number beside each record.

For example, in my table I have 3 results for a particular query:

blue
red
green

What I want is to use this query on a form and place a number in front of each. To show this output:


Now if there were 5 results for the query:

purple
yellow
orange
blue
green

I would want the output to look like this on my form:



I figured there was some built in function to do this automatically, but I haven't been able to find it!