使用DLookUp防止表单重复 [英] Using DLookUp to prevent duplicates in Form

问题描述

Hello All，


我已成功使用以下代码：

Hello All,

I''ve been successfully using the following code:

展开 | 选择 | Wrap | 行号

推荐答案

Alex，


所以，你想要它找出是否有一个具有相同AssetTag和Checkbox的记录检查？这可能有效：

Alex,

So, you want it to find out if there is a record with the same AssetTag AND the Checkbox checked? This might work:

展开 | 选择 | Wrap | 行号

谢谢twinnyfo，


确切地说，但不是我[AssetTag1 ...只看当前显示的记录而不是所有记录？不需要表单声明？


再次感谢，

Alex

Thanks twinnyfo,

Exactly, but won''t the "Me[AssetTag1..." only look at the current record on display and not all records? The form statement is not needed?

Thanks again,

Alex

@twinnyfo


如上所述并得到错误：


对象不包含Automation对象''Me''。

您试图运行Visual Basic过程来为对象设置属性或方法。但是，该组件不会使属性或方法可用于自动化操作。

@twinnyfo
Tried as above and got error:

The object doesn''t contain the Automation object ''Me''.
You tried to run a Visual Basic procedure to set a property or method for an object. However, the component doesn''t make the property or method available for Automation operations.

这篇关于使用DLookUp防止表单重复的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！