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!
9 2220 Rabbit 12,516
Recognized Expert Moderator MVP
Why do you need popup forms? Why not have the comboboxes in the main form and bind them to the fields in the table?
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?
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 12,516
Recognized Expert Moderator MVP
Let us know how you get along.
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 12,516
Recognized Expert Moderator MVP
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 & "'"
In these cases you need quotes. - "WHERE [ID] = '" & Me!Company & "'"
Thanks, that was the one thing I was missing. It works great.
Rabbit 12,516
Recognized Expert Moderator MVP Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Raffi |
last post by:
Here's my HTML code. What I'm trying to do is when the button is
pushed to refresh the popup window information, I want the popup to
return to the front. The way my code is now, when refreshed the popup
stays in the background confusing the users. Thanks for your help.
--------HTML Code------
<html>
<head>
<script language="javascript" type="text/javascript">
|
by: Uwe Range |
last post by:
Hi to all,
I am displaying a list of records in a subform which is embedded in a
popup main form (in order to ensure that users close the form when
leaving it).
It seems to be impossible to delete a record in this subform.
When I switched modal off and tried to delete a record from the list,
I deleted a record on another form (below the popup form).
|
by: aaa |
last post by:
I am bringing up a popup which has a couple of fields that the user enters.
I fill the hidden fields then submit and close the popup which then reverts
back to my main form, which retrieves the hidden vars and does the database
operation. Seems straight forward enough but I have run into a few stumbling
blocks including submitting then closing the popup and reverting control
back to the main form to pick up the variables.
Someone has to...
|
by: Macbane |
last post by:
Hi,
I have a 'main' form called frmIssues which has a subform control
(named linkIssuesDrug) containing the subform sfrmLink_Issues_Drugs.
A control button on the main form opens a pop-up form which allows me
to edit the record in the subform. What I want to happen is for
subform with the new edits to be updated on the main form when I close
the popup. I'm sure this is a very small bit of code in the the 'On
close' event for the popup...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |