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

Subform H*LL

P: n/a
DS
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
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
DS
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
Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

P: n/a
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
Nov 13 '05 #4

P: n/a
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


Nov 13 '05 #5

P: n/a
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
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.