I've got a scoresheet main form with a subform that is continuous
score forms. The links are TruckId, Judge & ClassId. But it's not
linking correctly. Whenever I move to the next scoresheet main form,
the subforms are still the same (same TruckId, Judge & ClassId as
before). Any tips?

How are your links defined in the subform container property:

Master:
Child:


--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista


"MattE" wrote:

> I've got a scoresheet main form with a subform that is continuous
> score forms. The links are TruckId, Judge & ClassId. But it's not
> linking correctly. Whenever I move to the next scoresheet main form,
> the subforms are still the same (same TruckId, Judge & ClassId as
> before). Any tips?
>
>

Master: Child:
TruckId TruckId
Judge Judge
ClassId ClassId

Thanks,
Matt

So in both the Master and Child Link Properties you have this line, as shown?

TruckId;Judge;ClassId


--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista


"MattE" wrote:

> Master: Child:
> TruckId TruckId
> Judge Judge
> ClassId ClassId
>
> Thanks,
> Matt
>
>

That's right!
Matt

On Oct 10, 1:01 pm, boblarson <boblar...@discussions.microsoft.com>
wrote:
> So in both the Master and Child Link Properties you have this line, as shown?
>
> TruckId;Judge;ClassId
>
> --
> Bob Larson

Sorry for the time between responses (very busy at work today), but the next
thing you have to do is make sure that the links are in logical order and do
you really need all three to get to where you want? How is the subform
recordsource created and what KEY field would be the one that would link to
the main form. Multiple keys can get funky at times, so if you don't have to
use them it's best to not.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista


"boblarson" wrote:

> So in both the Master and Child Link Properties you have this line, as shown?
>
> TruckId;Judge;ClassId
>
>
> --
> Bob Larson
> Access World Forums Super Moderator
> Utter Access VIP
> ____________________________________
> Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
> WinXP, Vista
>
>
> "MattE" wrote:
>
> > Master: Child:
> > TruckId TruckId
> > Judge Judge
> > ClassId ClassId
> >
> > Thanks,
> > Matt
> >
> >

Thanks for your help, no problem about the delay.

I changed it back to the way it was before (which I'd forgotten to
mention), so now Master is InternalId (the auto-generated long integer
id of each ScoreSheet) and Child is ScoreSheet (the long integer
ScoreSheet id in each Score record). Same problem! Ugh!

If you want to save time on this, you can email it to me at accessbob at
gmail dot com and remember to include info on where to look and what the
problem was (as I get lots of email and also deal with lots of posts so I can
forget easily which one it was).
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista


"MattE" wrote:

> Thanks for your help, no problem about the delay.
>
> I changed it back to the way it was before (which I'd forgotten to
> mention), so now Master is InternalId (the auto-generated long integer
> id of each ScoreSheet) and Child is ScoreSheet (the long integer
> ScoreSheet id in each Score record). Same problem! Ugh!
>
>

Thanks! I'm sending it now. Will try to remember the post the
resolution here later.
Matt