
Data Control and parameter query
Quote:
>I use a database with a QueryDef stored in it containing a parameter
>query. How can I manage to set the RecordSource property of a Data
>Control to that QueryDef and supply the required parameters to the query.
>Without parameters no problem...
>I would be very grateful for a nice tip.
>Wilfried
You cannot use a parameter query with a data control recordset property.
You can only use a paramater query if you create the dynaset in VB code.
The only thing you can do is build the SQL select statement and set it in the recordset
properity. I had this issue with a few tables in my database. The paramater query
ran fine, but the SQL ran slow. I had to de-normalize the tables for the
query to be acceptable. Sloppy but it worked.
BTW, if anyone knows how to get around this problem, feel free to jump in.
Sorry,
Scott.