I have a form with 2 Subforms...The first subform is linked to the main
form. The second Subform is liked to the first subform. Whenever I add
a record to the first subform that works fine. When I add a record to
the second subform that also works fine. The problem is the second
subform always shows all of the records that are in it. Whenever I
scroll through the records in the first subform, the records in the
second subform should only show the records related to the first
subform. The links seem to be working...I'm not getting an Error
message. Am I doing something else wrong.
Thanks
DS
5  1518 
DS wrote: I have a form with 2 Subforms...The first subform is linked to the main
form. The second Subform is liked to the first subform. Whenever I add
a record to the first subform that works fine. When I add a record to
the second subform that also works fine. The problem is the second
subform always shows all of the records that are in it. Whenever I
scroll through the records in the first subform, the records in the
second subform should only show the records related to the first
subform. The links seem to be working...I'm not getting an Error
message. Am I doing something else wrong.
Thanks
DS
Ok I've got it to partillay work...it's now in sync, the only problem is
that it's showing ALL of the records for that product, ot just for that
particlar order, any suggestions? Thnaks
DS
On the properties sheet of the second sub form,
check the LinkChild, LinkMaster properties...
my guess is that is where the problem lies...
or..
easy solution...
Make sure that the Design Wizard is turned on.
then delete the second subform (just from the main form, not from the
database) and then re-add it.
HTH
Mal.
"DS" <bo******@opton line.net> wrote in message
news:Q6******** ***********@fe0 9.lga... DS wrote: I have a form with 2 Subforms...The first subform is linked to the main
form. The second Subform is liked to the first subform. Whenever I add
a record to the first subform that works fine. When I add a record to the
second subform that also works fine. The problem is the second subform
always shows all of the records that are in it. Whenever I scroll
through the records in the first subform, the records in the second
subform should only show the records related to the first subform. The
links seem to be working...I'm not getting an Error message. Am I doing
something else wrong.
Thanks
DS
Ok I've got it to partillay work...it's now in sync, the only problem is
that it's showing ALL of the records for that product, ot just for that
particlar order, any suggestions? Thnaks
DS
Mal Reeve wrote: On the properties sheet of the second sub form,
check the LinkChild, LinkMaster properties...
my guess is that is where the problem lies...
or..
easy solution...
Make sure that the Design Wizard is turned on.
then delete the second subform (just from the main form, not from the
database) and then re-add it.
HTH
Mal.
"DS" <bo******@opton line.net> wrote in message
news:Q6******** ***********@fe0 9.lga...
DS wrote:
I have a form with 2 Subforms...The first subform is linked to the main
form. The second Subform is liked to the first subform. Whenever I add
a record to the first subform that works fine. When I add a record to the
second subform that also works fine. The problem is the second subform
always shows all of the records that are in it. Whenever I scroll
through the records in the first subform, the records in the second
subform should only show the records related to the first subform. The
links seem to be working...I'm not getting an Error message. Am I doing
something else wrong.
Thanks
DS
Ok I've got it to partillay work...it's now in sync, the only problem is
that it's showing ALL of the records for that product, ot just for that
particlar order, any suggestions? Thnaks
DS
I tried that. Didn't work. The Data changes as I go from one object to
another. The Master/Child fields seem to connected correctly. Heres
how my tables are set up.
ORDER TABLE Order ID
to
ORDER DETAIL TABLE Order ID, Product ID
to
PRODUCTS TABLE Product ID
to
MOD DETAIL TABLE Product ID, Mod ID
to
MODS TABLE Mod ID
Theres one more table here than the Northwinds Database has, I think
that I need a code snippet on the after updates of the second form.
Something that says choose only on current, but I don't have a clue how
to write it?
Thanks
DS
On Wed, 16 Feb 2005 10:52:02 -0500, DS <bo******@opton line.net> wrote:
There is a standard solution for that. You have to "publish" the
primary key value of SF1 on the Parent form, and then use
LinkMasterField s of SF2 to point to that control.
I typically use a hidden textbox, and set the ControlSource to:
=SF1.Form!PK_Fi eld
-Tom. I have a form with 2 Subforms...The first subform is linked to the main
form. The second Subform is liked to the first subform. Whenever I add
a record to the first subform that works fine. When I add a record to
the second subform that also works fine. The problem is the second
subform always shows all of the records that are in it. Whenever I
scroll through the records in the first subform, the records in the
second subform should only show the records related to the first
subform. The links seem to be working...I'm not getting an Error
message. Am I doing something else wrong.
Thanks
DS
Tom van Stiphout wrote: On Wed, 16 Feb 2005 10:52:02 -0500, DS <bo******@opton line.net> wrote:
There is a standard solution for that. You have to "publish" the
primary key value of SF1 on the Parent form, and then use
LinkMasterField s of SF2 to point to that control.
I typically use a hidden textbox, and set the ControlSource to:
=SF1.Form!PK_Fi eld
-Tom.
I have a form with 2 Subforms...The first subform is linked to the main
form. The second Subform is liked to the first subform. Whenever I add
a record to the first subform that works fine. When I add a record to
the second subform that also works fine. The problem is the second
subform always shows all of the records that are in it. Whenever I
scroll through the records in the first subform, the records in the
second subform should only show the records related to the first
subform. The links seem to be working...I'm not getting an Error
message. Am I doing something else wrong.
Thanks
DS
Thanks, I'll give it a try!
DS This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Josh C. |
last post by:
Hello everyone. I'm a bit of an Access newbie, so please bear with me.
Please go to http://www.dumoti.com/access/ to view the database - 536kb.
I'll go straight into examples:
In the form NIGO_ITEM, you'll notice a subform to the NIGO_REASONS table. It
won't let any data be entered into this subform and it gives the error: You
cannot add or change a record because a related record is required in table
CUSTOMER_TABLE. (Error 3201)
This...
|
by: Ima Lostsoul |
last post by:
Access XP
Access 2002 format.
I have a subform on a tab control. The subform has the following
code (error trapping removed to make post shorter)... When I close the
parent form it goes 100% as designed UNLESS I have used one of the sort
buttons to sort the sub form on any given field. If I do sort, there is
a delay fo about 5 seconds until after the parent form closes and the
previous form re-opens. It appears that there may be...
|
by: Lyn |
last post by:
Hi,
I am working on a genealogy form. The only table (so far) lists everybody
in the family, one record per person. Each record has an autonum ID.
The parent form (frmMainForm) displays the data in each record, which
includes the ID of the father and the mother (who also have records in the
table). One record per form.
I have a Tab Control in the form, and in one of the tabs I have a subform
(sfmSiblings) in which I wish to list...
|
by: Simon P |
last post by:
Hello group, I'm in desperate need of help. Here goes :
I have the following tables : CONTACTS (ContactID, FirstName,
LastName, Company, etc.), SHOWS (ShowID, ShowDescription) and
SHOWDETAILS (links the previous tables together so not to have a
many-to-many relationship -- has the ContactID and ShowID fields).
I have a main form with a couple of listboxes which are used for
querying the CONTACTS table. The results populate bound fields...
|
by: MLH |
last post by:
I have created two forms: frmBrowseNegsMainform and
frmBrowseNegsSubform. I put a subform control on the
first of these. The SourceObject property for the subform
control is, of course, frmBrowseNegsSubform.
I would like to perform an ascending or descending sort
on any of the 7 columns shown in datasheet view in the
subform control. I've been unsuccessful.
Is there something tricky about sorting in subform controls?
| | |
by: John Michael |
last post by:
I have a form that has a subform that has a subform.
The subform loads a record based on a combo lookup box in the main form.
I'm trying to set a value in the subform based on a value in a subform of
the subform.
the main Form is called
Subform is called
Subform in the subform is called
|
by: Bill Agee |
last post by:
I have a subform called PaymentDetails and would like to dynamically assign
the recordsource after the form/subform is opened.
The recordsource for Payment Details is "PaymentDetails_qry" which uses
a function to filter the Invoice #. The invoiceID is not known until after
the
form is opened. After the InvoiceID is selected from a dropdown I then
want to assign the recordsource
...
|
by: Karl Roes |
last post by:
I'm still having trouble posting follow-ups. :-(
"Unable to retrieve message
7cc66112.0501041919.3a6628b4@posting.google.com"
Now Turtle wrote "You'll need an extra field in the table underlying
the subform." ....................hmmmmmmmmm...................
I put in a field in the underlying table with a default value of 1.
I created a text box which adds up the values in the new field
|
by: DMUM via AccessMonster.com |
last post by:
Hello
I am trying to pass the name of my subform to a function/sub but I can't
seem to get it to work. I am using an autokey function (ctrl E) to unlock
text boxes on a subform. I have a few forms in the database that will use
this function, so I need to be able to tell the code which form to unlock.
What I have is as follows:
Public Function akeyEdit()
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
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: 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: 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.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
