I have problems with my current SQL language. I am trying to have a command button that will move the information that I am viewing from my MissingVendorInfo form to the a new entry in VendorContacts. There are additional columns in VendorContacts, but these are the appriorate ones for the transfer.

VendorContacts
- VendorName
- ContactFirstName
- ContactLastName
- Email
- Phone
- Fax
- Street
- StateProvience
- City
- PostalCode
- County
- Country

MissingVendorInfo
- Miss_VendorName
- Miss_ContactFirstName
- Miss_ContactLastName
- Miss_Email
- Miss_Phone
- Miss_Fax
- Miss_Street
- Miss_StateProvience
- Miss_City
- Miss_PostalCode
- Miss_County
- Miss_Country

Thanks for any help.

Ok, I got the SQL language to work, but now I am running into the problem that it does it for every entry. I am trying to just do it one row at a time.

Have you tried running an append query?

http://office.microsoft.com/en-us/access/HA011860631033.aspx