Access中数据表中的从属组合框? [英] Dependent Combobox in a Datasheet in Access?

问题描述

我已经创建了一个依赖的组合框，如本文所述. http://office .microsoft.com/en-au/access-help/basing-one-combo-box-on-another-HA001173058.aspx

I've created a dependent combobox as mentioned as this article. http://office.microsoft.com/en-au/access-help/basing-one-combo-box-on-another-HA001173058.aspx

但是，我遇到的问题是我正在尝试使用数据表来做到这一点.当我将条件指定为另一个字段时，它将查看第一行的值，而不是当前行的值.我也愿意以连续的形式进行此操作，但不知道是否有帮助.

However, the problem I'm having is that I'm trying to do this with a datasheet. When I specify the criteria as another field, it'll look at the first row's value instead of the current row's value. I'm willing to do this as a contiguous form as well, but don't know if that would help.

推荐答案

以连续形式进行的未绑定控件只会使您发疯.考虑修改基础查询，以确保您的组合基于绑定的列(字段).

Unbound controls in a continuous form will only drive you insane. Consider modifying the underlying query to ensure that your combo is based on a bound column (field).

这篇关于Access中数据表中的从属组合框?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！