I Hate My Popup Form Problems...Help!

[rousseaud]

I'm having some trouble getting popup forms to work properly. I have a main form that contains 4 fields that I want to fill in by using a series of 4 popup forms that I initiate by clicking a button. Each popup form has a save button that will save the data and open up the next popup form in the series. Each of the popup forms have a single combo box that looks at various tables to populate date into the main form. The problem I'm having is getting the series of popup forms to update the only the current main form record. No matter what I do, I haven't had any luck. Help, please!

[Rabbit]

Why do you need popup forms? Why not have the comboboxes in the main form and bind them to the fields in the table?

[rousseaud]

Why do you need popup forms? Why not have the comboboxes in the main form and bind them to the fields in the table?

Well, the series of popups will be defined by the user. I'm designing a structure that will point to different popup forms depending on the input from the last. In actuality, I'll have more like 15 popup forms (If user selects A in popup1, it will go to popup5. If I select B in popup 5, I will go to popup 8, etc.). Does that make sense?

[Rabbit]

You can do the exact same thing using one form by using Cascading Combo Boxes.

[rousseaud]

You can do the exact same thing using one form by using Cascading Combo Boxes.

Thanks! I'll give it a shot and see how it goes.

[Rabbit]

Let us know how you get along.

[rousseaud]

Let us know how you get along.

In the last line:

"WHERE [ID]=" & Me!Company

how can I have it look for text instead of a number?

[Rabbit]

In the last line:

"WHERE [ID]=" & Me!Company

how can I have it look for text instead of a number?

In these cases you need quotes.

"WHERE [ID] = '" & Me!Company & "'"

[rousseaud]

In these cases you need quotes.

"WHERE [ID] = '" & Me!Company & "'"

Thanks, that was the one thing I was missing. It works great.

[Rabbit]

Good Luck.