I have 4 databases in MS Access 2010 (Data is in SQL Server 2008) Front end only in MS Access 2010. I've been tasked with building a new front end and migrating the 4 different Databases (from 4 different departments) into a new combined database so all 4 departments are able to see the other departments data and to merge those records that exist in different departments but are for the same person. I've built the data structure for the new database and am now working on migrating the data from the 4 into the new database but I'm getting a weird error. I have a do loop to loop through each record in the departmental database step one is to import the customer data into the new structure. the new structure also includes a primary key of the first four letters of the last name plus the first four letters of the first name plus the DOB in the format mmddyyyy So John Johnson born 1/1/1974 would be JohnJohn01011974

I then have a nested do loop to take the existing data and export it to the related tables for that customer.

the issue is that on the outer loop I'm getting an error that states there's no do associated with that loop but I've rechecked the code and there are 2 do statements and 2 loop statements so the error makes no sense.