Inserting Data into a Table in Datasheet View

[McLiguori]

I have a table with 15 to 20 records in it. Only one field. I use the table for a combobox drop down list. I need the entries to appear in the order I enter them into the table, therefore no querries, sorting etc. At times, I need to insert a new list item for example between the 12th and 13th item (record) already in the table. I cannot find a way to 'insert' this 'new' record where I want it. The only options seems to be to add it as the last record. A workaround is to recreate all the records in the desired order including the new entry. But, this becomes very inefficient as the list gets longer.

In Access 2007, is there a way to insert a new record between two existing records into a table open in datasheet view? The only command I can find in the table design tools is "insert a new field" or "insert a new column". What I need is "insert a new record". Can't find it!

Thanks for any help you can provide!

McLigs

 

[PHV]

You should add a column for sorting your rows.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886