Pop up forms

[Lindros]

I'm creating a database. On the form, if you answer a certain way, another form pops ups and then if something in the pop-up form has a certain answer a third form pops up. I have no problem creating the extra forms. I've done that. I also created a macro to open the form and go to a new record.

I have a couple of problems. First, if the answer on the original form is something you choose from a drop down, what formula do I use and where do I put it so that Access knows that the pop up form needs to open? It's different than just a yes/no answer where you can enter the macro name in the "onclick" property.

Second, once they fill in what is on the pop up form, how can I get it to close and go back to the original without having to manually close it? When I manually close the pop up I get an error message about the macro. I think it might confuse people if they have to manually close anything.

Same problem goes if I have two pop up forms open. How can I get them to close properly and go back to the original form?

I would love to hear any suggestions on a better way to set up this form. Should I even be using the pop up forms? Is there an easier way that is still user friendly? There will be several people entering data and they are not exactly bright when it comes to this stuff. I need to avoid too much complexity.

Thanks for your help and if I can provide anything further let me know.

Michelle

 

[Remou]

I guess the idea is that if I answer say, Yes, to Question X, you want to know why? How about using Set Focus? This way you can set the focus to the Why box and refuse to move until you get an answer. I think pop-ups can become quite confusing.

 

[TheAceMan1]

How are ya Lindros . . .

[blue]First, if the answer on the original form is something you choose from a drop down, what formula do I use and where do I put it so that Access knows that the pop up form needs to open?[/blue]

Kinda hard to tell without further info (so far I'm thinking a [blue]Select Case[/blue] statement).

Post an example of whats in the combobox and what determines if you open the popup(s) . . .

See Ya! . . . . . .

 

[sdk]

Hi

It looks like you should be looking at the condition proporties in the macro - here you can conditionally run a macro, or macro steps, dependant on values in your txt boxes on the popups. Set the macro/s to run on the AfterUpdate property of (each) textbox control.

If the first popup is redundant when opening the second, can you use the macro to preset values or to control ranges so that the first popup? I would venture that cascading popups for data input suggest something not quite right - either with the form design or process.

If updating the initial combobox on your data entry form controls permissible values in other fields, you can use other methods to control this (lists that are dependant on the combobox, range controls etc). This might be more intuitive and passive.

Cheers

S