当我在键盘上键DEL时，如何删除子表中的行？ [英] How to delete a row in a sub table when I key DEL on my keyboard?

问题描述

大家好，

请有人帮我找到解决方法，如何删除子表中的行。每次我尝试删除该行时，我都会弹出一个菜单，说你即将删除1条记录。如果单击是，则无法撤消删除操作。


单击是时，表示该记录已删除。但是一旦我刷新。记录仍在那里。它仍然在表中。


您的解决方案请..

Hi every body,
Please can somebody help me to find a solution how to delete a row in a sub table. Each time I try to delete the row, I got a pop up menu saying "You are about to delete 1 records. If you click yes you won''t be able to undo the delete operation."

When I click yes, it shows that the record is deleted. But as soon as I refresh. the records is still there. It remains in the table.

Your solution please..

推荐答案

您是否已关闭表格并重新开启？

你真的看过数据表吗？


有一点需要注意：在VBA中，表单的刷新与Requery不同。刷新不会对绑定表单的记录集显示任何添加或删除，而Requery强制表单返回数据表并需要记录。

Have you closed the form and re-opened?
Have you actually looked at the data tables?

One thing to note: In VBA, Refresh for a form is not the same as Requery. Refresh will not show any additions or deletions to a bound form''s recordset whereas the Requery forces the form to go back to the data table and require the records.

我还没有现在写了任何代码。我用F5刷新它。请强制删除子表中的行的VBA代码是什么？

I haven''t written any code for the moment. I refresh it with F5. Please what is the VBA code to force to delete the row in the sub table?

我已关闭并重新打开。一样的。我已经检查了关系船了，没关系。记录集类型已从动态集更改为动态集（更新不一致）。还是一样。我想我们需要一些代码来强制删除...

I have closed and re-opened. Its the same. I''ve checked the relation ship as well, its ok. The recordset type have been change from dynaset to dynaset(inconsistent update). Still the same. I think we need some codes to force it to delete...

这篇关于当我在键盘上键DEL时，如何删除子表中的行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！