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

Why don't sub forms link correctly on opening

P: 2
I am using Access 2007 linked to SQLserver tables
I have a sub form that links to an intermediate form on a main form, when I first open the main form the link between the main form and the intermediate form is not established until I select the next record on the main form then it links to the correct records fine.
Why should this be and how can fix it?
There are no problems with the link between the intermediate form and the sub form.
Jan 19 '10 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 3,532
Does the first record on main form have a corresponding record on the intermediate form?

Linq ;0)>
Jan 19 '10 #2

P: 2
Yes it has and when I move on to the second record and then go back to the first it is linked correctly.
Jan 20 '10 #3

Expert 2.5K+
P: 3,072
Guess you'll ned to force Access to process/requiry the subform.
Try in the OnCurrent event:
Expand|Select|Wrap|Line Numbers
  1. Me.subformname.SourceObject = Me.subformname.SourceObject
This should force Access to activate the needed table.

Jan 22 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.