pass Where to query from form

[homer]

Hi,
I want to find a way to pass a Where clause to an pre-built query either
from form or from code module in Access 97.
Because the select statement is pretty lengthy and involves many joins, I
want to stay away from pasting the whole statement. Instead, I saved it in a
query.
I looked under OpenQuery, QueryDef, and RunSQL, but none of them meets my
need.

OpenQuery: I did not find a way to pass the where clause to the method.
RunSQL: I did not find a way to bring in existing query sql.
QueryDef seems come most close to what I need. The Parameter will take my
where clause, and the name property will bring in the pre-built query.

Am I on the right track? Can somebody show me an example of querydef, name,
parameter work together?

Thanks!

 

[Jerry Whittle]

In the criteria of the query reference the value in a form's text box like so:

=[Forms]![FormName]![TextBoxName]

 

[homer]

Are you talking about QueryDef or OpenQuery? I cannot assign the text value
to the criteria in the design time of the query, because the query will be
called from multiple places.

In the criteria of the query reference the value in a form's text box like so:

=[Forms]![FormName]![TextBoxName]
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Hi,
I want to find a way to pass a Where clause to an pre-built query either
from form or from code module in Access 97.
Because the select statement is pretty lengthy and involves many joins, I
want to stay away from pasting the whole statement. Instead, I saved it in a
query.
I looked under OpenQuery, QueryDef, and RunSQL, but none of them meets my
need.

OpenQuery: I did not find a way to pass the where clause to the method.
RunSQL: I did not find a way to bring in existing query sql.
QueryDef seems come most close to what I need. The Parameter will take my
where clause, and the name property will bring in the pre-built query.

Am I on the right track? Can somebody show me an example of querydef, name,
parameter work together?

Thanks!