OpenQuery Parameters?

[jachbow]

Name: Picture1.png  Views: 12  Size: 52.7 KB  ID: 46313" class="thumbnail" style="float:CONFIG" />Hello,

I am wanting to have an OpenQuery Macro in one of my forms that automatically inputs the content of the field as the parameter to the query. As of right now, I have an OnDblClick event embedded in the column I want but the query does not automatically run. Upon further research, I think a solution may be to edit parameters in the macro itself but I can't seem to find where to do this; any ideas? Attached is a simplified example of the form's current state. After I double click on a letter the prompt opens to run a query. I am wanting the query to run with the letter automatically inputted as the constraint.


Thank you

[Micron]

I don't use macros but suspect that your query should use the form field as criteria and not a parameter prompt. Something along the lines of

...WHERE myField = Forms!Example.Col_1...

I would have thought that you should be filtering on the ID field, not Col_1.