I have been having trouble updating and referencing a combobox located in a subform. The combobox in question's row source is tied to a query that narrows the users choices based upon a previous entry in another combobox. The query does not work correctly; when you select the combobox, the control reference pop-ups as a null value each time.
Currently, I referring to the combobox control as [Forms]![Proposal]![Tests subform]![cbotestm], which works when you run the query separate from the form, but doesn't when the query is run through the combobox row source. I have seemingly tried every other syntax I can locate for the control name, e.g. [forms]![Proposal].[form]![Tests subform]![cbotestm], none of which seem to work.
Thanks for help in advance.