Set Dynamic Combo Box RowSource in an Access Continuous Subform
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.

- 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.
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.
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.
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.
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.
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.
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.
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.

Requery a cascading combo box for the current record
Use this approach when the list only needs to be correct for the active row while the user edits it.
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.

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.




