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

Problem with subform master-child links (Access 2000 - SP3)

P: n/a
I have a prototype that has a main form with multiple tabs that are
dynamically loaded based on the process chosen from a menu. The main form is
linked to the projects table and the subforms are linked to various project
details. As long as I select a project that has subform details all is well.
I can select numerous projects in a row and the subform displays the correct
data. As soon as I select a project with no subform details (empty
recordset) the link between the parent and sub seems to become broken. I get
an empty recordset even if I select a new project with sub details and the
display is stuck on the last project with sub details. If I refresh the
subform links (reselect the process from the menu) the display is updated
with the current recordset.

I'm sure I could work around this problem by refreshing the links every time
I select a new project, but I'd rather avoid the overhead. Is this a known
bug? Any ideas what may be causing the issue?
Aug 18 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.