create parameters dynamically?

C

Craig Buchanan

I would like to create a form that searchs for incidents. Obviously, the
user might select any combination of criteria. I have a query that does the
table joins that are needed and displays the appropriate fields.

I would like to be able to create parameters in code and somehow modify the
query to accept these parameters.

Is there a way to do this?

Otherwise, i can always write dynamic sql.

thanks,

craig
 
M

Marshall Barton

Craig said:
I would like to create a form that searchs for incidents. Obviously, the
user might select any combination of criteria. I have a query that does the
table joins that are needed and displays the appropriate fields.

I would like to be able to create parameters in code and somehow modify the
query to accept these parameters.

Is there a way to do this?

Otherwise, i can always write dynamic sql.
Click to expand...


Bo way
 
M

Marshall Barton

Craig said:
I would like to create a form that searchs for incidents. Obviously, the
user might select any combination of criteria. I have a query that does the
table joins that are needed and displays the appropriate fields.

I would like to be able to create parameters in code and somehow modify the
query to accept these parameters.

Is there a way to do this?

Otherwise, i can always write dynamic sql.
Click to expand...


Create the SQL dynamically.

If the query is being used as the record source for form or
report that you're going to open, then just construct the
OpenForm/OpenReport's WhereCondition argument.
 
Top