Results 1 to 2 of 2
  1. #1
    Rude Awakening is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2014
    Posts
    4

    Reset Autonumber in Form

    Hey All
    I deleted the ID(PK)[Autonumber] field in a table and readded a new one in order to reset the ID to 1 because testing is finished and I can roll it out.

    However the form still has the incremented autonumber there(23 at the moment), I already connected it to the new field but this hasnt reset the number on the form.



    Any ideas?
    Cheers.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Try emptying the table and then doing a compact/repair.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. reset autonumber
    By slimjen in forum Forms
    Replies: 4
    Last Post: 07-22-2014, 05:31 AM
  2. Reset autonumber field and delete records?
    By clebergyn in forum Programming
    Replies: 7
    Last Post: 02-20-2014, 07:32 PM
  3. AutoNumber reset
    By Seeletse in forum Access
    Replies: 3
    Last Post: 12-12-2012, 07:14 AM
  4. Reset autonumber in a concatenate field
    By Fish218 in forum Forms
    Replies: 6
    Last Post: 03-13-2012, 11:58 AM
  5. Query to Reset AutoNumber to 1 after full delete
    By saigovind in forum Queries
    Replies: 1
    Last Post: 02-04-2011, 03:43 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums