删除子表单中的选定记录（查询） [英] Deleting selected records in subform (query)

问题描述

美好的一天先生

我有一个由3个表组成的子表，它们合并在一起形成一个查询来开发子表单。

请如何从中删除记录子窗体？

当我删除时，我想立即更新其余记录

谢谢先生

解决方案

如果你想要从表单中删除当前记录，那么以下代码将确保更新反映在当前会话中而无需 Me.Requery ：

展开 | 选择 | Wrap | 行号

谢谢先生提示回复

请问我在哪里放置此代码？

是否会在表格上或在子窗体？

主窗体中的子窗体由3个不同的表组成。

子窗体是一个连续窗体，我想放一个删除按钮将立即删除记录

请提供任何帮助将被赞赏

谢谢

如果您需要从中删除记录然后你需要在那个表单上创建一个Command Button控件，并将代码放在 Click 命令按钮的事件过程中。

Good day sir
Please I have a subform composed of 3 tables merged together to form a query to develop the subform.
Please how do I delete record from this subform?
As I delete, I want the remaining records updated immediately
Thanks sir

解决方案

If you want to delete the current record from a form then the following code will ensure that the update is reflected in the current session without the need for a Me.Requery :

Expand|Select|Wrap|Line Numbers

Thank you sir for the prompt reply
Please where do I place this code?
Is it going to be on the form or on the Subform?

The Subform in the main form is formed from 3 different tables.
The subform is a continuos form, I want to put a delete button on it that will delete record immediately
Please any help rendered will be appreciated
Thanks

If you need to delete a record from the form on your subform then you''d need to create a Command Button control on that form and place the code in the Click event procedure for the Command Button.

这篇关于删除子表单中的选定记录（查询）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！