rs.FindFirst不工作 [英] rs.FindFirst not working

问题描述

我有一个用于更新详细信息表中记录的表单。有一个未绑定的组合填充了表中的可用记录。我在组合的AfterUpdate事件中有以下代码。

I have a form for updating records in a details table. There is an unbound combo populated with the available records in the table. I have the following code in the AfterUpdate event of the combo.

展开 | 选择 | Wrap | 行号

推荐答案

Knowlton，


我使用相同的语法，它工作正常。您似乎使用组合框作为搜索项目？


组合框是否具有ID和值？您当前的代码正在寻找组合框的值，它应该是一个索引，但是设置为文本字符串。


组合框的行源是什么？

Knowlton,

I used identical syntax and it works fine. It appears you are using a Combo Box as your search item?

Does that Combo Box have an ID and a Value? Your current code is looking for the value of the Combo Box, which should be an index, but is set up as a text string.

What is the row source for your combo box?

Twinnyfo很可能在那里有解决方案

打开表单，查看 Me.cboTag的[row source]属性在数据选项卡下，也是[bound column]值。

Twinnyfo most likely has the solution there
Open your form, and look at the [row source] property of Me.cboTag under the data tab, also the [bound column] value.

组合只有一列可见，它是绑定列，是标签，它是一个文本领域。查询中有3个条件列，用于将梳子限制为尚未更新的记录。

The combo has only one column visible which is the bound column and is the Tag which is a text field. There are 3 criteria columns in the query to limit the comb to records which have not been updated.

这篇关于rs.FindFirst不工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！