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  1497 
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******@optonline.net> wrote in message
news:Q6*******************@fe09.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******@optonline.net> wrote in message
news:Q6*******************@fe09.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******@optonline.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
LinkMasterFields of SF2 to point to that control.
I typically use a hidden textbox, and set the ControlSource to:
=SF1.Form!PK_Field
-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******@optonline.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
LinkMasterFields of SF2 to point to that control.
I typically use a hidden textbox, and set the ControlSource to:
=SF1.Form!PK_Field
-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...
|
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...
|
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...
|
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...
|
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,...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
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: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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: 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: 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...
|
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,...
| |
