Happy New Year Everyone!

I have a questionaire database that I am designing for work. For each of the 4 sections, there are option groups that can be answered yes or no. If the answer is no for the section, I want a pop-up form that prompts the user to enter comments.

I need to assign a value from the questionaire form to the comments form (i.e. If the answer on the questionaire form for section I is No, then I want the comments form to open with the option group set to 1 and the ID to = the questionaire ID.

Can anyone help?

I think the simplest way would be to add 4 comment fields to the table that holds your questionaire data (one for each section). Once this is done you can build 4 small forms and bind them to the same table. Bind each comments field to the feild that matches the Section. Open the pop up form on the AfterUpdate of each Option Group and specify which pop up form to add. You may want to consider how large you can afford to make the comment fields.
HTH
Chris