Binding a combobox in subform Access

user137263 picture user137263 · Aug 3, 2012 · Viewed 12.9k times · Source

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)

Answer

Fionnuala picture Fionnuala · Aug 3, 2012

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

A combo on a subform

The relationships

relationships for the tables