bad subform link

M

MattE

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?
 
B

boblarson

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
 
B

boblarson

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
 
B

boblarson

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
 
M

MattE

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!
 
B

boblarson

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
 
M

MattE

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