Binding a combobox in subform Access

ms-access combobox subforms
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

Related questions

How to populate a ComboBox with a Recordset using VBA

There is some literature available at expert's exchange and at teck republic about using the combobox.recordset property to populate a combobox in an Access form. These controls are usually populated with a "SELECT *" string in the 'rowsource' properties of …

Read More
How to populate the value of a Text Box based on the value in a Combo Box in MS Access 2007?

I have a combo box which is of a lookup type, i.e., I've selected the source to be a column from a table and am storing the selected value in another table. The table which I am looking up …

Read More
Getting Combobox.Value in Access VBA

I have this code: If Me.Combobox.Value = "My Text" Then As I want to test if "My Text" is the only value selected, however, the conditional is skipped. I have also tried Me.Combobox.Column(1) and Me.Combobox.Text …

Read More