I am using Access 2003. I have a database with a field "Shipper#" that I want the default value to 1 larger than the previous record. I also want to be able to override the number, sometime we will have 5 lines with the same shipper#, most rows will have a different shipper#. I have tried the...