选中多个复选框时如何隐藏行。 [英] How to hide row when multiple check boxes are checked.
问题描述
Windows 10平台上的MS Office 2016。我正在使用访问权限,以便购买者团队可以在每次需要订购时生成采购订单编号。我正在使用此系统跟踪产品已收到,发票已输入我们的财务数据库,并且我们收到了订单确认。我为这3个活动中的每一个都设了一个复选框。一旦检查了所有3个盒子,我希望该行变得隐藏,这样我就可以更快地获得仍然未完成的图片。谢谢。
MS Office 2016 on Windows 10 platform. I am using access so that a team of purchasers can generate purchase order numbers every time they need to order something. I am using this system to track that the product was received, an invoice was entered into our financial database, and that we received a confirmation for the order. I have a check box for each of those 3 events. I would like the row to become hidden once all 3 boxes are checked so I can more quickly get a picture of what is still outstanding. Thanks.
推荐答案
表单的RecordSource必须符合条件,例如
The RecordSource for the form must have something in the criteria like
感谢您的快速回复。虽然这有点过头了。我会点击什么来输入这样的代码?我会打开表并在数据库工具选项卡下选择一些内容吗?
Thank you for the quick response. This is a little over my head though. What would I click on to enter in a code like that? Would I open the table and select something under the database tools tab?
OK表单的RecordRource是什么?它通常是一个查询,您可以通过在数据选项卡上按设计视图中的3个垂直点来查看。
Phil
OK What is the RecordRource for your form? It is usually a query which you can view by pressing the 3 vertical dots with the form in design view on the Data tab.
Phil
这篇关于选中多个复选框时如何隐藏行。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!