The next bit is to get all that infomation to display in the IFA2 Form. I have worked out in the test form (Form1) That i will need some VBA code to input all the infomation relating to an ID number or Name. However once I did this i realised that the form (Form1) couldn't be edited or records couldnt be added, so I am happy to have a duplicate of IFA2 (Form adding) which will update the tables from the form and have the original IFA2 as a form to view all the records.
As you can see IFA2 is quite detailed, and when the form is being looked at for each individual, I want the checkboxes in the tables that corrospond to that individual to be checked (as per checkboxes in the tables).