子表单链接问题 [英] Subform Linking problem

问题描述

嗨


我遇到子窗体问题，我正在使用Access 2007，但DB的格式是2003，运行os Xp。


这是问题所在，我有一个主表单设置为单个表单并将自动打开以此表单添加新记录我已经放置了一个子表单，用于显示连续记录同一个部门（我已经清除了主链接和子链接，并通过代码获取记录集）。在子表单上，我设置了几个按钮，这些按钮将为子表记录集调用不同的SQL集。 2天前，这个工作完美，今天它刚刚停止，只会显示与主窗体中当前记录具有相同ID的字段。子窗体，当它打开时它自己仍然可以工作。

我检查了链接的字段，它们仍然被清除，我已经在主窗体上注释掉了我的所有VBA，我有压缩并修复了数据库并选择了子窗体并在页面上将其替换为物理清除链接的字段，它仍然无法像2天前那样工作。


我很乐意相信这是一个简单的错误，但目前我认为这是恶意灵魂未知的工作。


任何帮助都会很棒，甚至是方向。


任何更多的信息或细节请问我是否愿意。

解决方案

有时我从我的数据库中得到莫名其妙的行为，并且反编译将解决它。这一系列步骤可能有所帮助：从腐败中恢复

谢谢你，我已经完成了文章中的所有项目，但它仍然被打破了。


任何人都可以。

< blockquote>你说你正在使用代码来获取子表单的记录集，但是你说你注释掉了代码。现在设置记录集的是什么？

Hi

I''m having problems with a subform, I''m using access 2007 but the DB''s format is 2003, running os Xp.

This is the problem, I have a main form which is set to be a single form and will auto open to Add New Record in this form I have placed a subform which is to show continuous records for the same department (I have cleared the master and child links and get the record set via code). On the sub form I have set a few buttons which will call different sets of SQL for the subforms recordset. 2 days ago this worked perfectly, today it has just stopped and will only show fields which have the same ID as the current record in the main form. the subform, When opened on it''s own still works.
I have checked for the linked fields and they are still cleared, I have commented out all of my VBA on the main form, I have compacted and repaired the db and delected the subform and replace it on the page physically clearing the linked fields and it still does not work as it did 2 days ago.

I would be happy to believe that this is a simple error but at present I believe it to be the work of malicious spirits unknown.

Any help would be great, even a direction.

Any more info or detail please ask i am more than willing.

解决方案

Sometimes I get inexplicable behavior from my database, and a decompile will fix it. This set of steps may help: Recovering from Corruption

Thanks for that, i''ve run all of the items in the article but still it is broken.

Any more anyone.

You said you are using code to get the recordset for the subform, but then you said you commented out the code. What is setting the recordset now?

这篇关于子表单链接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！