bad subform link

  • Thread starter Thread starter MattE
  • Start date Start date
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?
 
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
 
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
 
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
 
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
 
Thanks! I'm sending it now. Will try to remember the post the
resolution here later.
Matt
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Type mis match in expression on a form 2
Set Change Event on Control from Nested Subform 0
Access Main form/Subform Navigation 0
Expression is typed...... 2
Unremovable horizontal scroll bar on subform 1
Subform of subform not being linked 3
Update subform with combobox change on main form 1
First Subform record gets modified when closing form 3

Back
Top