Microsoft Access找不到表达式中引用的字段“我” [英] Microsoft Access can't find the field 'I' referred to in your expression
问题描述
每当我删除记录我的命令按钮，记录删除，显示所有记录的列表都会更新，然后会出现一个消息框：
Microsoft Access不能找到你的表达中提到的我字段
它只能点击确定，当我这样做时一切都很好。
我想知道发生了什么以及如何解决这个问题。下面是我认为问题所在的部分代码。
表单是基于tblDeviation的frmDeviation，显示用于导航的所有记录的列表是lstDeviation，它们是几个其他列表显示其他表中的相关记录。
Hi, Whenever I delete a record my command button, the record deletes, a list displaying all records is updated and then a message box appears:
Microsoft Access can''t find the field ''I'' referred to in your expression
It only has the option of clicking ''OK'', when I do this everything is fine again.
I would like to know what is going on and how to fix this problem. Below is parts of the code that I believe the problem is in.
The form is frmDeviation based on tblDeviation, the list displaying all the records used for navigation is lstDeviation, and their are several other lists which display related records in other tables.
推荐答案
请你可以发布你的代码的哪一行出现此错误消息。
BTW假设我。最后一行的lblDeviationCount 引用一个Label控件，如果你想让它工作，你需要将值赋给 .Caption 属性。
Please can you post which line of your code this error message appears after.
BTW Assuming the Me.lblDeviationCount of the last line refers to a Label control, you need to assign the value to the .Caption property if you want it to work.
进行编译，它至少应该跳转到导致问题的代码的一般区域。
Do a compile and it should at least jump to the general area of the code that''s causing the problem.
这篇关于Microsoft Access找不到表达式中引用的字段“我”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
