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
|
|||
|
|||
AutoNum Field
My table has a RecordId field, data type "AutoNum." I made a form in design
view for the table. In the form the RecordID field number will not advance when I add a new record. I need help in trouble shooting this problem. I work in Access 2007. |
#2
|
|||
|
|||
AutoNum Field
Let's confirm we exactly what the problem is:
This is an Access (JET) table, and in table design view, this field's data type shows as AutoNumber. Therefore in your form, when you move to a new record is shows "(AutoNumber)" in the text box until you start adding a new record. Then on the first keystroke as you start to enter the new record, this text box changes to show the number, but it's the same number used by a previous record. Even if you press Esc to undo the record, you still get a previously-used number. (The same one again?) If that's the case, try a compact/repair (Office Button | Manage.) If it's a split database (i.e. the table is attached from another Access db), open the back end (the database that actually contains the table), and compact/repair it. If that doesn't work, run the code in this article: Fixing AutoNumbers when Access assigns negatives or duplicates at: http://allenbrowne.com/ser-40.html Also make sure there is no Default Value for this text box. And if this is actually a subform, make sure the AutoNumber field is not linking the field to the main form (LinkChildFields property of the subform control.) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "northstar" wrote in message ... My table has a RecordId field, data type "AutoNum." I made a form in design view for the table. In the form the RecordID field number will not advance when I add a new record. I need help in trouble shooting this problem. I work in Access 2007. |
Thread Tools | |
Display Modes | |
|
|