If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Autonumber tables
My autonumber in my table database skipped from 1017 to 1019 but not in my
form. What would cause this to skip a number in my table |
#2
|
|||
|
|||
Autonumber tables
Hi Cindy
Your table does not always sort on the autonumber (or record 1018 was deleted). The make the form sort in a specific way create a query based on your table then sort this query how you want. Open the form in design view and use the new query as the record source. This will ensure the order of records is shown in a way that you decide (in the query sorting) -- Wayne Manchester, England. Enjoy whatever it is you do "cindy" wrote: My autonumber in my table database skipped from 1017 to 1019 but not in my form. What would cause this to skip a number in my table |
#3
|
|||
|
|||
Autonumber tables
AutoNumber will develop gaps!
Form example, when you start adding a new Record, JET will allocate a value to the AutoNumber Field for this new Record. If, for some reason, you cancel the addition, the allocated value will NOT be recovered and the next new Record will (usually) be allocated the next value. If you referred to the number in the Navigation Bar of your Form, that is NOT the value number of your Record. It is actually the RecordNumber of the Record in the Form's Recordset. Note that the AutoNumber value of a Record is fixed but the RecordNumber depends on your selection criteria and the sorting on your Form. Try sorting your Form Descending and it is likely that the RecordNumber of each Record will be different from the AutoNumber value. -- HTH Van T. Dinh MVP (Access) "cindy" wrote in message ... My autonumber in my table database skipped from 1017 to 1019 but not in my form. What would cause this to skip a number in my table |
Thread Tools | |
Display Modes | |
|
|