I have an application with a VB6 front-end and an Access 97 back-end. The primary table in the database is a general information Group table. The Primary Key for the table is GroupNo. I am looking for the best method to copy an existing record to a new record with the same GroupNo concatenated with a designated suffix. This is quite easy entirely within Access using Insert SQL. What is the best way in VB?