以子形式选中几个方框 [英] Ticking several boxes in a sub form

问题描述

你好。


我相信有一个简单的解决方案，不知道为什么我的工作不起作用？


在主窗体中我有一个& ;关闭勾选框。在子表格中，我还有几个相关的记录，每个记录都有一个封闭的记录。复选框。


我想要做的就是勾选关闭字样。主窗体中的框，它会自动勾选关闭框。子表格中的方框。


我试过这个。

展开 | 选择 | Wrap | 行号

解决方案

它不起作用，因为即使您可以看到子表单中的所有记录，其中只有一个是当前记录。您必须使用RecordsetClone属性逐步浏览子窗体中的记录并一次更新一个


Don

您好。


谢谢你让我朝着正确的方向前进。我现在可以看到为什么它不起作用。我现在已成功输入以下代码，并且勾选适用于所有


但是我也想通过使用订单号并添加/来应用交货单编号。 "和每个记录所属的瓮号。

展开 | 选择 < span class =codeDivider> | Wrap | 行号

您正在尝试添加你的字符串，所以你需要用单引号将它们括起来：

展开 | 选择 | Wrap | 行号

Hi there.

I am sure there is an easy solution to this and not sure why mine doesnt work?

In the main form I have a "closed"tick box. In the sub form I also have several related records each of which have a "closed" tick box.

What i want to do is tick the "closed" box in the main form and it automatically tick the "closed" boxes in the sub form.

I tried this.

Expand|Select|Wrap|Line Numbers

解决方案

It''s not working because even though you can see all of the records in the subform only one of them is the current record. You will have to step through the records in the subform using the RecordsetClone Property and update them one at a time

Don

Hi there.

Thanks for putting me in the right direction. I can see now why it wasnt working. I have now successfully put in the following code and the tick is applied to all

However I am also wanting to apply a delivery note number by using the order number and adding a "/" and urn number that belongs to each record.

Expand|Select|Wrap|Line Numbers

You are trying to add the " to your string so you need to enclose them with single quotes IE :

Expand|Select|Wrap|Line Numbers

这篇关于以子形式选中几个方框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！