By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,190 Members | 2,204 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,190 IT Pros & Developers. It's quick & easy.

I Hate My Popup Form Problems...Help!

P: 17
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
Share this Question
Share on Google+
9 Replies


Rabbit
Expert Mod 10K+
P: 12,359
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

P: 17
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
Expert Mod 10K+
P: 12,359
You can do the exact same thing using one form by using Cascading Combo Boxes.
Apr 26 '07 #4

P: 17
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
Expert Mod 10K+
P: 12,359
Let us know how you get along.
Apr 27 '07 #6

P: 17
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
Expert Mod 10K+
P: 12,359
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

P: 17
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
Expert Mod 10K+
P: 12,359
Good Luck.
Apr 27 '07 #10

Post your reply

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