Mapping parameters from embedded form within a form MSACESS

Question

I am trying to get a query to update based on a value passed from a combo box within the same form. After I moved the form into a tabbed control box within another form it seems to have broken. I've tried mapping from the outer form to the combo box and still an error to provide parameters into the query.

The Outermost form is "workbench" The tab control is "tabbed_space" The inner form is "software_list" The combo box is "cmb_server_selection

I have in the query

=[Forms]![workbench]![tabbed_space]![software_list]![cmb_server_selection]

What am I doing wrong?

Answer 1

Tab controls do not affect the "navigation path" of objects, the objects are still directly on their form.

To get objects on a subform, you need SubformControl.Form!Object

So it should be

=[Forms]![workbench]![software_list].Form![cmb_server_selection]

Note: this is easier to debug in the Immediate Window (Ctrl+g) than in the query (the form must be open of course) :

? Forms!workbench!software_list.Form!cmb_server_selection