I am building an Access database that constantly requires maintenance. To the best of my knowledge, the only way you can create a new record in Access is to select the "new record" command, and that will place your new record at the end of the record set. I need to be able to "sandwich in" new records between already existing records. Does anyone know how to do this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Adding records in Microsoft Access
- Thread starter bethm
- Start date
Databaseguy
MIS
No can do. A new record is always added to the end of the recordset. You can always run a query, and sort. Or, if you want to get really dangerous, recreate the recordset in the order you like. Tyrone Lumley
augerinn@gte.net
augerinn@gte.net
- Status
Similar threads
- Locked
- Question
