Access VBA in a From (when checkbox is ticked then put "text" in field in table)

[N3w2access]

I have 2 tables both linked to SQL Server 1 has policy information and the other has error information both tables are linked with the relationship policy Ref. The error table(table2) has fields Pol ref, Error_Type,error, Comments, response_comments and response_Date. There are 25 types of error so what I have done is copy all fields from table 2 25 times exlcusing the policy ref and Error_Type but to make them relate to the relevent error I need to setup some VBA code that does an if Error1_checkbox is ticked then make Error_Type ="error1" and Error=1 else if error1_checkbox is unticked then make error_type null(blank).

I hope this is clear but any help on this would really really grateful as I have been trying to do this for a long time and cant figure it out. im sure its a quick if statement but I dont know how to write it as I dont know access VBA.
If you need any screenshots or more info please let me know. im using ACCESS 2010

Many thanks

[June7]

What do you mean by 'copy all fields from table2 25 times'? Copied them where?

If you want to provide db for analysis, follow instructions at bottom of my post.

[N3w2access]

Sorry for not being more specific. On the form it will have a label called: Error_Type and fields: Comments, Response_comments and Response_Date from Table2 with a checkbox to state whether it is an error or not. These fields will need code so they only relate to the Error_Type Error1 and they will only record into the table2 when the checkbox is ticked and removed it unticked. As there are 25 types of error the Error_Type can be anything from Error1 - Error25 so I need to copy all the fields for Error_type1 25 times and rename and relate them to the relevant Error_Type. I will attached a screenshot to show what I mean as an example. The main thing is when the checkbox1 is ticked then make Error_Type Error1 if the next checkbox is ticked then make Error_Type Error2 and so on. I will also have to make the fields relate to the correct error_type. If this does not work I will send a copy of the DB but missing the confidential data. Thanks

[June7]

No image attached to post.

Sounds like you need a single combobox that presents the error types as a list of choices instead of a bunch of checkboxes.

[N3w2access]

The reason for the checkboxes so that the analyst can make sure each error has been checked also the analyst needs to leave a comment for every error found so that the comments relates to the error Ive tried attaching a picture but I dont think it has attached. Many thanks

[June7]

Attach image or db file. Follow instructions at bottom of my post.

Sounds like db structure is not normalized. Really need to see something.

[N3w2access]

I believe the screenshot has now attached.

[June7]

Still not seeing any image.