Subform: record select form other subform

[Guest]

Boy do I feel dumb. Once I changed to ClinetID on both subforms and the
query to an inner join...I have success. I see it now...and it is rather
simple.

Thanks so much for the hand-holding. You folks are a valuable resource even
to beginners (more like single-purpose users) like me.

BTW...where was my head? I got your response but never went to page 2. Duh!

 

[Guest]

One more thing, if I may impose...

I have additional subforms on adjacent tabs (on that same third level) the I
would like to retrieve the record for the InvNum selected on the continuous,
displayed on the single, and then displayed on those adjacent tabs. Now that
ClientID is the Master/Child for the first two, the others don't pull up the
correct reocrd. Currently they are set to InvNum and I have tried
combinations of M/C ClientID and InvNum to no avail.

Is there a coding way to sync those other suboforms with the InvNum as
selected on the continuous form?

 

[Marshall Barton]

Boy do I feel dumb. Once I changed to ClinetID on both subforms and the
query to an inner join...I have success. I see it now...and it is rather
simple.

Thanks so much for the hand-holding. You folks are a valuable resource even
to beginners (more like single-purpose users) like me.

BTW...where was my head? I got your response but never went to page 2. Duh!

Glad to hear that things are finally working.

I guess one lesson to be learned from all this is that it's
the little details that require a lot of our attention.

There might be some value in revising your debugging
technigues. It is important to find ways to isolate tests
to as few components as possible. In this case, the biggest
road block to finding the Link Child problem was using the
search procedure to look at the single form. If we had
bypassed the continuous form and just gone directly to the
single form to look at all the records, it would have been
immediately apparent what was wrong.

 

[Marshall Barton]

One more thing, if I may impose...

I have additional subforms on adjacent tabs (on that same third level) the I
would like to retrieve the record for the InvNum selected on the continuous,
displayed on the single, and then displayed on those adjacent tabs. Now that
ClientID is the Master/Child for the first two, the others don't pull up the
correct reocrd. Currently they are set to InvNum and I have tried
combinations of M/C ClientID and InvNum to no avail.

Is there a coding way to sync those other suboforms with the InvNum as
selected on the continuous form?

Have you tried doing the same thing as we did for the
invoice details form? Don't forget to check these other
forms without going through the continuous subform.

Beyond that general comment, I will need all the details
about these other forms, especially the code you tried and
which field is being searched along with the type of the
field.