在子窗体Access中绑定组合框 [英] Binding a combobox in subform Access

问题描述

我有一个子窗体，它具有正确的源对象，链接主字段和链接子字段参数。

I have a subform which has the correct Source Object, Link Master field and Link Child field parameters.

我可以在子窗体中创建一个组合框，在下拉菜单中显示正确的信息（与子窗体的源对象相同的表），但未绑定，并且不更新主窗体中的记录。

I can create a combobox in the subform which shows the correct information in the drop down menu (same table as the source object of the subform), but is unbound and does not update the record in the main form.

有没有人知道如何解决这个问题？

Does anyone know how this might be fixed?

表，但已启用引用完整性和级联更新）

(note the relationship between Master and Child is over multiple tables, but has referential integrity and cascade updates enabled)

推荐答案

组合在子窗体上的事实与此案件。向导将为您设置一切，但绑定控件的规则是设置控制源。例如，您的子表单包含PlaceID的地方列表，并且您希望使用显示用户在组合中的地名列表的组合进行更新。

The fact that the combo is on a subform is not relevant in this case. The wizard will set everything for you, but the rule for binding a control is to set the Control Source. For example, your subform contains a list of places by PlaceID and you wish to update it using a combo that shows the user a list of place names in a combo.

 Control Source: PlaceID
 Row Source    : SELECT ID, PlaceName FROM Places ORDER BY PlaceName
 Bound Column  : 1
 Column Count  : 2
 Column Widths : 0; 2cm

关系

这篇关于在子窗体Access中绑定组合框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！