Record numbers

  • Thread starter Thread starter lyle mark
  • Start date Start date
L

lyle mark

How Do display the record numbers on a report?
I tried using auto number and displaying that on the
report but when it a record is deleted it srews up the
numbering. I need a simpe way of displaying the record
number on the report that users can search for on the form
 
You'll need to add a field to your table and create your own "record
number". Access Autonumbers are designed to provide a unique row
identifier, and aren't generally fit for human consumption. A simple way to
generate a record number is to take the largest previous value and add
one -- something like (actual syntax may vary):

DMax("YourField","YourTable") + 1

By the way, if someone deletes a record with either an Autonumber or your
customized record number, that number will STILL be missing when users
search or report!

Generally, a form is easier for users to use if they don't have to enter
record numbers -- have you considered a combobox that lets them look up a
record based on something more meaningful than a number?

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top