Copy records

[-td-shadow]

In a Quote System there is two tables with a one to many relationship. I want to be able to copy a certain quote number and create a new one. In the past I created a recordset and then assigned each fields value to the matching form field. There must be a better way...can you help?

thanks

 

[doulostheou]

In the past, I have used the RunSQL command to move records. Create an Append Query that moves your record to the appropriate table but be sure to set the criteria to the specific quote number on the form. After the append query is setup, switch to SQL view. Copy the SQL and use this in conjunction with the docmd.RunSQL command in visual basic. There may be a better way; but if I have a lot of fields involved, this is the way I have always done it.