Copy record from on table to another and change a few fields before add.
Posted on 2012-04-06
Ok, I am pretty lost here......
The table that I'm reading from is SupplierRFQ, it has one record. I want to copy that one record(all fields) to SupplierRFQSlt which is identical to the SupplierRFQ table with the exception of a few fields. I am using a query that loops through a contact database that has contacts. I need to add the record from SupplierRFQ to SupplierRFQSlt for each contact in the query and populate the additional fields(SupplierRFQContact) in SupplierRFQSlt during that add.
The query loop I have in place is working fine with the exception of the above question.
Please provide code using my table names and field name, I'm new to VBA.......