Hello,
Try to explain this as best as I can.
I have a main form with several cmd buttons, (Not interested in subforms for this project) that opens popup forms.
Example: Main form frmPerson, cmd button cmdVehicle, when clicked opens frmVehicle displaying control boxes to be populated by the user. My problem is that I can't figure out how to link this PopUp Form frmVehicle to the main form, frmPerson.
I tried openargs but when I attempt to create a new record, the form is refreshed and the openargs linking is not working.
Any help is greatly appreciated,
Thanks,
2  4091 
Hello,
Try to explain this as best as I can.
I have a main form with several cmd buttons, (Not interested in subforms for this project) that opens popup forms.
Example: Main form frmPerson, cmd button cmdVehicle, when clicked opens frmVehicle displaying control boxes to be populated by the user. My problem is that I can't figure out how to link this PopUp Form frmVehicle to the main form, frmPerson.
I tried openargs but when I attempt to create a new record, the form is refreshed and the openargs linking is not working.
Any help is greatly appreciated,
Thanks,
'Assuming [ID] is the Linking Field between frmPerson and frmVehicle, and
'you are populating frmVehicle with Child Records to frmPerson:
In the Current() Event of frmVehicle place the following line of code: - Me![ID] = Forms!frmPerson![ID]
Hello,
Try to explain this as best as I can.
I have a main form with several cmd buttons, (Not interested in subforms for this project) that opens popup forms.
Example: Main form frmPerson, cmd button cmdVehicle, when clicked opens frmVehicle displaying control boxes to be populated by the user. My problem is that I can't figure out how to link this PopUp Form frmVehicle to the main form, frmPerson.
I tried openargs but when I attempt to create a new record, the form is refreshed and the openargs linking is not working.
Any help is greatly appreciated,
Thanks,
You need to add criteria to the DoCmd.OpenForm statement
e.g. -
Dim stLinkCriteria
-
-
stLinkCriteria = "[ID]=" & Me.ID
-
-
DoCmd.OpenForm "frmVehicle", , , stLinkCriteria
-
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Hemanth |
last post by:
Hello there,
I'm running a script that opens a popup window (which is basically a
form with checkboxes and a submit button). When I click the submit
button I want to run a PHP script and target...
|
by: Deano |
last post by:
I have a main/subform arrangement which works well. The main form's parent
records are about employees. The subform calculates their salary.
I have now decided that the user can enter some...
|
by: Dave Boyd |
last post by:
Hi,
I have two very similar forms each with a subform. The main form gets
a few fields from the user and passes this back to a query that the
subform is bound to. The requery is done when the...
|
by: NBruch |
last post by:
Ok let me explain what im trying to do:
i need a combo box which needs to be linked to a listbox (or combo box
doesnt matter which really) then the listbox should bring up the record
in a...
|
by: VMI |
last post by:
How can I transfer some text from a Textbox in a popup window to the main
webform that opened that popup?
The popup webform will have some type of Button that the user will click in
order to...
|
by: CJONES |
last post by:
I have a main form and use a combo box to open a pop up form. The
combo box lists customers and only one customer requires the fields
that are found on the pop up form.
I can get the form to pop...
|
by: CJONES |
last post by:
I have a main form with a combo box where if a specific customer is
selected a popup form opens and additional information required for
this customer is entered into the form. Data from the main...
|
by: Thelma Roslyn Lubkin |
last post by:
I am still having trouble trying to use a popup form to allow user to
set filters for the main form.
The main form is based on a single table.
The popup contains 5 listboxes, so the user can...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
| |
