Popup window for entering data

[Miceros]

All,

I've been working in this database with lot of text involved. I work for a
domestic violence agency and I'm designing a database where we can keep
track of all our clients. There is a lot of text involved and what I'm
trying to do is have a pop up window come up if the guest answer Yes to a
question.

Example: In a form with many Yes/No questions I would like to have pop up
window linked to a text field and allow the user enter info. If the user
answer No, it will continue to the next question without having to close the
pop up window.

Do I need to create some kind of Event procedure or Macro something like
that?, If I do could you show how to do it?

Thanks

 

[Maquis]

You can trigger a pop-up from the on_change event of your radio buttons. (I'm assuming you have a main form with lots of Yes/No questions with Yes/No radio buttons as the way to answer the questions).

In the on_change event of the button check to see if the value of the option group is "Yes". If so, then open the appropiate pop/up. (docmd.openform "formname&quot
Maq
<insert witty signature here>

 

[Miceros]

I don't have a radio button. I have a combo box with Yes/No as value list. I want if the choose Yes to bring a popup box linked to another field in another table.

Example: main form question: Are you afraid of anyone at this moment? if answer YES, a popup window will appears linked to another field in another table NOT another form. I like to store these answers on separate tables instead of the main table.

 

[Maquis]

The concept is the same with combo boxes.

The pop-up window is another form with a big text box and the appropiate table as it's control source. You said you don't want another form to pop-up, but that is exactly what you need. (Something has to pop-up, and a form is the best object for the job).

Go ahead and create the pop-up forms with the appropiate fields and tables then it will be easier to code your main form to call the pop-ups. Maq
<insert witty signature here>