Show Comment Box Text in Query

[TreeHugger4]

I have a comment box in a subform. When I type a comment in it, the comment shows up the proper table (so that part works.. yay!). However, I would like to run a query that shows any comments made that corresponds to the data in that same table. All of the data comes up when I run the query, but the comment area stays blank. What am I doing wrong/overlooking?

 

[Endre]

Firstly ensure your reference is in the following format :

[Forms]![MAIN_form_ID]![SUB_form_ID].[Form]![CommentBox_ID]

For a partial match in your query use:

Like "*" & [Forms]![MAIN_form_ID]![SUB_form_ID].[Form]![CommentBox_ID] & "*"

And finally, don't forget to add it into your Parameter List:

From the menu option use: QUery > Parameters

and add the reference exactly in the same format as above:

[Forms]![MAIN_form_ID]![SUB_form_ID].[Form]![CommentBox_ID]

and define the data type.

If this doesn't help, post your query and we can have a better look.