Others

Set Dynamic Combo Box RowSource in an Access Continuous Subform

Elise WilliamsElise Williams Nov 14, 2026 868 views

Question details

The user needs a bound combo box in an Access 2013 continuous subform to offer choices based on each record's Upstream_LineItem_Name value.

Set a Dynamic Combo Box RowSource in an Access Continuous Subform
Product
Microsoft Access 2013
Device & OS
not provided
Scenario
A continuous subform displays multiple records, each of which may require a different list of valid combo box choices.
Observed behavior
A VBA RowSource solution works for the first record but not for the remaining displayed rows.
Before you start

Open the subform in Design View and identify the combo box's Control Source, bound column, and the table or query containing its choices. Confirm which field in that source matches Upstream_LineItem_Name.

Solution 1Recommended

Use a filtered selection form for each subform record

Use a separate selection form when each row needs its own filtered choices without changing the shared combo box RowSource.

A continuous form repeats the appearance of one combo box control; it does not create a separate control or RowSource for each displayed row. A filtered selection form can instead show choices for the currently selected record.

1
Create a selection form

In Access, select Create > Form Design and build a form based on the table or query that contains the available choices. Include the choice ID, display label, and the field used to match Upstream_LineItem_Name.

2
Open the form for the current row

Add a button to the continuous subform in Design View. In its On Click event, use DoCmd.OpenForm with the current record's Upstream_LineItem_Name passed through OpenArgs, and open the selection form as a dialog.

3
Filter the choices

In the selection form's On Load event, read Me.OpenArgs and apply a filter to the matching field. If building a text filter in VBA, escape apostrophes in the value; handle null or empty values explicitly.

4
Write the selected value back

Add a Select button or a double-click event to the selection form. In that event, assign the selected choice ID to the bound combo box on the parent form's current subform record, then close the selection form.

5
Test multiple records

Open the parent form in Form View, select different subform rows, and use the selection button. Verify that each dialog shows the correct choices and that the selected value is saved to the intended row.

Use a filtered selection form for each subform record
Keep displayed values available: If the original combo box displays a label from a lookup RowSource, keep that RowSource broad enough to resolve saved values across all visible rows. Filtering it to one row can make labels in other rows appear blank.
Free Microsoft Office alternative

Use WPS Office for Related Spreadsheet Work

WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Open compatible Office files to move related reporting work into WPS easily. WPS Office does not edit Access forms or run Access VBA, so use Microsoft Access for this database task.

Review and organize exported database data in WPS SpreadsheetsOpen and edit compatible Microsoft Excel XLS and XLSX filesUse a familiar interface for everyday Office document workGet a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does changing RowSource affect every row in my continuous form?

Access displays repeated instances of the same combo box control in a continuous form. Changing its RowSource changes the shared control, not an independent combo box for one row.

Can I filter the combo box when I move to another record?

Yes. Use the subform's On Current event to requery a RowSource that references the current record. The list will be filtered for the active record, but the RowSource remains shared across visible rows.

Why do combo box labels disappear in other rows?

If a saved bound value is not present in the current RowSource, Access may be unable to resolve its display label. Keep saved values available in the display lookup or use a separate filtered selection form.

How can I pass the current row's value to a selection form?

Use DoCmd.OpenForm from a subform button's On Click event and pass Upstream_LineItem_Name through OpenArgs. Read Me.OpenArgs in the selection form's On Load event and use it to filter the choices.