需要过滤组合框但只需要新记录 [英] Need to filter combo box but only new records

问题描述

我的数据库中有一个包含子表单的表单，用于管理交付。子窗体上的组合框显示库存项目和当前状态。组合框后面的代码是......

I have a form with a subform in my database that I use to manage deliveries. A combo box on the subform displays items of inventory and thier current status. The code behind the combo box is...

展开 | 选择 | Wrap | 行号

推荐答案

@Richard Penfold


我对您的要求有点模糊，但对我而言，您似乎希望根据是否或者动态更改第一个组合框的RowSource不是新记录。一般的想法类似于：

@Richard Penfold
I am a little hazy on your request, but to me it appears that you wish to dynamically change the RowSource of the 1st Combo Box based on whether or not it is a New Record. The general idea would be something similar to:

展开 | 选择 | Wrap | 行号

您好ADezii，

您有正确的想法，但我不认为我在第一篇文章中给了你足够的信息。

Deliveries_Inventory是一个绑定控件组合框

Hi ADezii,
You have the right idea but I don''t think I gave you enough information in my first post.
Deliveries_Inventory is a bound control combo box

展开 | 选择 | Wrap | 行号

@Richard Penfold


因此，如果我理解正确，在您从Deliveries_Inventory组合框中选择一个项目后，如果这是一个新记录，您希望显示Deliveries_Inventory中的所有条目不卖的。同样，如果是新记录，您还希望在子表格中显示已售出的记录吗？

@Richard Penfold
So, if I understand you correctly, after you select an Item from the Deliveries_Inventory Combo Box, and if this is a New Record, you wish to display all entries in Deliveries_Inventory that are not Sold. Again, if it is a New Record, you also wish to display Records in the Sub-Form that are Sold?

这篇关于需要过滤组合框但只需要新记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！