Want "line" numbers in a form

L

lumpy

I'm new to access. I've got a form with a list box table that is populated by a query. Since I often have to discuss the individual records with others over the phone it would be very convienient to have each record identified with a line number. Is it possible to do this easily? Since the query returns a subtotaled and sorted list of the records, I don't want a field in the source table

thnaks
 
S

Stephen Lebans

See:
http://www.lebans.com/rownumber.htm
Rownumber.zip is a database containing functions for the automatic row
numbering of Forms, SubForms and Queries.

Updated Oct. 13 by Allen Browne. Includes error handling and cleaned
code.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


lumpy said:
I'm new to access. I've got a form with a list box table that is
populated by a query. Since I often have to discuss the individual
records with others over the phone it would be very convienient to have
each record identified with a line number. Is it possible to do this
easily? Since the query returns a subtotaled and sorted list of the
records, I don't want a field in the source table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top