nb88 Posted February 15, 2006 Report Share Posted February 15, 2006 Right......ive made a form that creates a new 'order' - its for my school's sports equipment. I created some example data and entered it into the form. This made the data come up in the 'Order' table. The primary field, 'Order ID' is in autonumber format. I deleted all the example data from the table by simple deleting the rows. However, now when i create a new piece of data on the form, it autonumbers it, not as 1, but as the last autonumber.For example, i added 9 pieces of example data. I then deleted them all. But on the form the autonumber still comes up as 10, not as 1.Very very annoying!!!!! Does anyone know how to stop it?Cheers. Quote Link to comment Share on other sites More sharing options...
nb88 Posted February 15, 2006 Author Report Share Posted February 15, 2006 Sorted it now no worries.If anyone was wondering, i copied and pasted the table as 'Order1', deleted 'Order' and renamed 'Order1' to 'Order'. Worked a charm its a bit gay that access doesnt do it automatically though. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.