为什么我的OnChange活动不起作用？ [英] Why won't my OnChange event work?

问题描述

我有一个文本框，我用作搜索字段：txtAddress。我有一个使用Like关键字基于该字段的查询，以便我可以使用通配符。我想要发生的是，当我将每个字符键入txtAddress时，子表单（基于查询）重新查询。这是我目前所拥有的：

I have a textbox that I''m using as a search field: txtAddress. I have a query that is based on that field using the Like keyword so that I can have wildcards. What I would like to happen is that as I type each character into txtAddress, the subform (that is based on the query) requeries. Here is what I currently have:

展开 | 选择 | Wrap | 行号

推荐答案

我指的是表单而不是特定字段赛斯。


。文字& .Value属性应该在它们之间提供你所追求的东西。我不确定哪个在这个阶段更有用，但测试将决定。

Me refers to the form rather than the particular field Seth.

.Text & .Value properties should, between them, provide what you''re after. I''m unsure which is the more useful at this stage, but testing will determine that.

我认为做 Me.dirty = false 保存了记录。我不熟悉.Text或.Value（我假设你的意思是.Value而不是.Vaue）属性，所以我做 Me.Text.Dirty = False 或我。 txtAddress.Text.dirty = False ？

I thought that doing the Me.dirty = false saved the record. I''m not familiar with the .Text or .Value (I assume you meant .Value not .Vaue) properties, so do I do Me.Text.Dirty = False or Me.txtAddress.Text.dirty = False?

我假设您提到txtAddress用作未绑定的搜索字段。因此，我认为保存记录并不重要。


当您通过代码或查询引用控件时，通常会引用控件的VALUE。 />

I presume as you mention txtAddress is used as a search field that it is unbound. As such I don''t think it should matter saving the record.

When you reference a control whether by code or query, you will usually reference the VALUE of the control.

展开 | 选择 | Wrap | 行号

这篇关于为什么我的OnChange活动不起作用？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！