The Row Source Type property will tell Access where to get the data from to display in the control.This data can be displayed from either one of your database tables, a query, a list of items or a list of field names from a table, query or SQL statement.
So far - I've built an app 100% code free but now I have hit a wall. Well - there are more than 2 fields but only 2 I care about in this issue. This would work in either situation (stand-alone form or sub-form in a navigational form). However - Set Property doesn't allow an update to Row Source. In a second related question - I have another form with 2 fields I care about: Risk Type and Risk Value. also if you design the navigation form you can work in the subform at the same time So put the subform in the navigation form and afterward you must open the navigation form in design view to edit the subform.
The first field is "Sector." The second is "Industry." The values in the "Industry" combo box list will be different depending on which Sector is selected. ......[cbx Sector ID] is different than when I'm using the form - because I have the form embedded in a Navigation Form. However, when I'm using the form in the navigational panel, it needs to say [Forms]! Risk Type could be "percent based" or "specific amount." Depending on which is selected, I want Risk Value to be formatted as a percent or as currency. However - again - Set Property doesn't appear to allow changes to Format. I would suggest you make a home page instead of the navigation/subform.
A second click on the same node does update the list to the expected values; when another node is clicked the list again is wrong (it contains the list related to the next to last assigned rowsource, instead of related to the last one assigned).
Is there some delay in activating the combo box' rowsource? ms-access vba combobox | this question edited Mar 6 '12 at asked Mar 6 '12 at Maestro13 2,575 4 30 55 OK found a solution for this myself - I don't particularly like it (*), but it does work, so I regard it as a temp workaround, until somebody else provides a solution using the royal route (setting rowsource and somehow make this have the desired effect).
The listbox can have anywhere from 1 to 12 columns.
The users want the results of this query to be able to be exported to Excel.
A subform combo box control's list of values depends on the node selected in the treeview on the main form.
I am trying to achieve refresh of the combo box drop down list contents on the subform as follows: But oddly enough, this does not update the list of values.
Coupled with how slow it is, it is very likely that the user will cause an error, trying to manipulate the form before the looping is completed.