OpenQuery or RunSQL

[Ofina]

I am trying to open a table filtered for a specific selection from a button on a form.

I can not figure this out. I have created a query that displays the contents of the table, but can't figure out how to get it to filter.

OpenQuery doesn't appear to have a way to pass parameters. RunSQL I have read is for action sql, inserts, deletes, etc, not just selects.

The parameter I want to pass is determined by which line item on the form contains the button clicked.

 

[Ofina]

Actually, I think I was able to get this to work. I had the data I wanted on a form and displaying and filtering properly. I just wanted it in a datasheet view. Just realized that I can open the form in datasheet view and have the results that I want.

However, now I'm having a column heading problem.