Query Parameter

[mrxdotcom]

is there anyway to find out if a query has a parameter(s) programmatically. for a example, i have several queries and i wanna check the queries first before passing a parameter(s) to the query.

any idea will be useful.


Mrxdotcom

 

[mrxdotcom]

Thanks Pat

thanks for guiding me....i have solved the problem. if anyone else is interested.. this is how i solved it..

Set myQuery = db.QueryDefs(cmbDisplayQueryName.Text)
ParCount = myQuery.Parameters.Count