We have created a database for our help desk and one table is an asset database. The data from a spreadsheet was imported into the database as it's historic. The problem is when new assets have to be added to the database. I have a field called ID but I have to manually add the data to the Assets table (which is linked) so the form can pick up the current information. Because the data was imported, I was unable to make the datatype for ID an autonumber. I need help on opening a new form and the next number in the sequence is filled in. Thanks to anyone who can help me with this.