It is possible. What kind of checkboxes? In any case it is likely possible - although with 94 questions it would take a lot of code - to simply get the value of a checkbox and action document C appropriately.

Fot example:

If Question 1 = No, then put "blahblah" into document C.

It takes a lot of detail work and you must be absolutely precise in the logic...NO vagueness. It also takes decisions about how the "responses" are put into Document C. Are they boiler plate? Do you write them? Do they already exist in another reference document? Are they bookmarked?

I have done this with 60 questions. It takes a lot of work, but it was for a survey going out to 1200 network admins and there was no way I was going to do all the respnse documents by hand. You are correct, it is time consuming and very prone to error.

Fumei,

Thank you for the response. Yes the logic is clear and the same every time. Also the responses are boilerplate, I will have analysts reviewing the response documents prior to them being sent back, but at least if I can get this to part to work, they are only massaging the boilerplate language that is there. Also the check boxes are legacy form field boxes.

So could you give me a quick example or sample of code, and possibly explain how I would link the two documents, where I would put the code (I'm thinking it would have to be in document C).

Thanks so much, I do appreciate the help. Like you I have a total of about 9800 of these to do. I didn't pick the format to send them out in either, or I would have recommended/researched out a better option prior to starting the project.

Thanks,
Dave

You could store your variable language in AutoText in your template.
Each checkbox should be assigned a bookmark name. Your code tests for its value, and based on the value inserts code.

See Doug Robbins' answer in this thread for sample vba code for an on-exit macro for your checkboxes. http://social.technet.microsoft.com/...do-not-display

Rather than a protected form or in addition to it you might want to consider using a UserForm which has the advantage of not needing to have your checkboxes in the final document. Create a Simple Userform
Create & Employ a Userform

Charles,

I'll look into the on-exit macro you mentioned and thanks for the idea about the Userform, but like I said, I didn't develop the template and it has already been sent out.

Thank you for the idea though, I'm going to check out that link as well and perhaps it will come in handy for the next revision of this project.

Dave