468,740 Members | 2,022 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,740 developers. It's quick & easy.

I Hate My Popup Form Problems...Help!

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!
Apr 26 '07 #1
9 1903
Rabbit
12,515 Expert Mod 8TB
Why do you need popup forms? Why not have the comboboxes in the main form and bind them to the fields in the table?
Apr 26 '07 #2
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?
Apr 26 '07 #3
Rabbit
12,515 Expert Mod 8TB
You can do the exact same thing using one form by using Cascading Combo Boxes.
Apr 26 '07 #4
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.
Apr 27 '07 #5
Rabbit
12,515 Expert Mod 8TB
Let us know how you get along.
Apr 27 '07 #6
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?
Apr 27 '07 #7
Rabbit
12,515 Expert Mod 8TB
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.

Expand|Select|Wrap|Line Numbers
  1. "WHERE [ID] = '" & Me!Company & "'"
Apr 27 '07 #8
In these cases you need quotes.

Expand|Select|Wrap|Line Numbers
  1. "WHERE [ID] = '" & Me!Company & "'"
Thanks, that was the one thing I was missing. It works great.
Apr 27 '07 #9
Rabbit
12,515 Expert Mod 8TB
Good Luck.
Apr 27 '07 #10

Post your reply

Sign in to post your reply or Sign up for a free account.

By using this site, you agree to our Privacy Policy and Terms of Use.