Display Query Row Number on Form?

[crhodus]

I have a form that displays the query results in the detail section. I would like to add a label or text box in the detail section that will display the row number of that query (1, 2, 3, ....) so that each record in the detail section will have a number next to it.

I want the number displayed so that if the user decideds to print the results from the form, they will have a number next to each record so they don't have to loose their place when viewing the "report".

Can anyone help? Hopefully I haven't confused anyone.

Thanks!

 

[dcx693]

Why would the user lose his/her place? Short attention span?

I don't know of an easy way to use a form to number a query, but there are ways to number queries using the query itself. I've never tried them though: Roger's Access Library. Look for " NumberedQuery.mdb (34 KB) ( beginner ) Access 97 "

 

[crhodus]

I have some odd users. Anyway, thanks for the link. The example was what I was looking for!