NotInList让我发疯（呃） [英] NotInList making me crazy(er)

问题描述

大家好，

对于已经退出正常工作的NotInList代码块感到有点悲伤。

我已将其设置为模块中的public sub我可以用多种形式使用它。我在表单模块中工作正常，但在公共模式下似乎有些不好。


新值似乎没有采取，尽管acdataAdded它会继续弹出标准警告，告诉用户在第二个消息框关闭后从列表中选择一个项目。最终数据不会被添加。

组合框源是：

展开 | 选择 | Wrap | 行号

解决方案

忘了提到cbo框中的可见列是文本字段，而绑定列是自动编号ID字段。


再次感谢

< blockquote class =post_quotes>
Hello all，

对于已经退出正常工作的NotInList代码块感到有点悲伤。

我设置了它作为模块中的公共子，所以我可以在mul中使用它tiple形式。我在表单模块中工作正常，但在公共模式下似乎有些不好。


新值似乎没有采取，尽管acdataAdded它会继续弹出标准警告，告诉用户在第二个消息框关闭后从列表中选择一个项目。最终数据不会被添加。

组合框源是：

展开 | 选择 | Wrap | 行号

您的Not-In-List代码块旨在从组合框的NotInList（）事件中触发，而不是在公共过程中触发。如果你想让它有点便携并从Public Sub-Routine运行它，将NewData作为参数传递给Sub-Routine，现在可以在其中访问它，如：

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

Hello all,
Having a bit of grief with a NotInList code block that has quit working properly.
I have set it as a public sub in a module so I can use it in multiple forms. I t worked ok in the form module but seems to be a bit glitchy in the public mode.

The new value does not seem to be taking and in spite of "acdataAdded" it continues to pop up the standard warning telling the user to pick an item from the list after the second message box closes. Ultimately the data doesnt get added.
Combo box source is:

Expand|Select|Wrap|Line Numbers

解决方案

Forgot to mention that the visible column in the cbo box is a text field while the bound column is an autonumber ID field.

Thanks again

Hello all,
Having a bit of grief with a NotInList code block that has quit working properly.
I have set it as a public sub in a module so I can use it in multiple forms. I t worked ok in the form module but seems to be a bit glitchy in the public mode.

The new value does not seem to be taking and in spite of "acdataAdded" it continues to pop up the standard warning telling the user to pick an item from the list after the second message box closes. Ultimately the data doesnt get added.
Combo box source is:

Expand|Select|Wrap|Line Numbers

Your Not-In-List code block is meant to be fired from the NotInList() Event of a Combo Box, and not in a Public Procedure. If you wish to make it somewhat portable and run it from a Public Sub-Routine, pass NewData as an Argument to the Sub-Routine, where it can now be accessed, as in:

Expand|Select|Wrap|Line Numbers

这篇关于NotInList让我发疯（呃）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！