In MS Access2007, I want to query (q_Notes) a table (t_Notes) in which one of the fields (t_Notes.Topic) is populated from a Combo Box based on a field in another table (t_Topics.Topic). I will have a table of several hundred records. I want to use the q_Notes query as the basis for a report showing all the notes posted for any given topic.
I've created a form (f_TopicSelect) that includes an unbound Combo Box (cboTopics) based on that same table and field (t_Topics.Topic) as in the t_Notes table that will be queried. When viewed as a stand-alone form, the Combo Box displays the list of values as expected.
I've specified the Combo Box as the criterion for the Topic field in my q_Notes query as follows:
(I know the spellings are correct because I used the "Build..." function to insert these values.)
When I run the query I get a Text Box that prompts me for the value of "Forms!f_TopicSelect!cboTopics" rather than the expected Combo Box listing of allowed values. The Property Sheet for this control assures me that it is a Combo Box, that the Row/Source type is "Table/Query" and the Row Source is "t_Topics".
If I edit the properties of the Combo Box in any way and save the changes (and even if I then change them back to what they were in the start), no prompt of any kind appears for the Topic -- neither a Text Box nor a Combo Box.
Any ideas what might be going wrong here?