Script for printing select fields.

[Triple]

Hey guys,

I need a little help to get me pointed in the right direction. I have a flat database which is basically a questionnaire. Next to each question, I have a checkbox. I'm trying to figure out a script that would add fields, if they are checked, to a "output" form that can then be printed and omit the fields that are not checked.

Any ideas?

Thanks

[NBEA Intern]

I don't know if this is the optimal way of doing this, but it's the way I would approach it.

I would create a new layout with a huge "Memo" field on it. Then, when going to print, I would look at each checkbox: If it's selected for what you want, append "Question X selected" or something like that to the memo field. Then, you can keep appending throughout all questions.

Though, like I said, I don't know if this is the best way to do it, just how I would start to approach it.

- Dan

[bcooney]

I typically wait for comment to chime in on questionnaire problems. Here is a link to an old thread in which he shows how to structure a questionnaire.My link