OpenQuery question

[richard luft]

Hi;
Is there any way of defining a select query (in AC2) as SQL, and opening this query from a code using 'OpenQuery' method or 'RunSQL' as the operand?.

 

[richard luft]

thanks. It would just be so easy to click a command btn and open a query on screen, and I was hoping-----

 

[richard luft]

Just realized that I'm having difficulty including a parameter in the form recordsource.
I'm using:
SELECT DISTINCTROW SERVICES.*
FROM SERVICES
WHERE ((SERVICES.InvoiceNum=[Enter InvoiceNumber]));
When the form opens, I'm getting a prompt for the parameter, but the tform opens with no fields present.
Any suggestions as to what I'm missing?