refer to a query in vba to change its sql?

[Ruegen]

So your answers are:

There is an Access query object with that SQL statement.

You want code to replace the sql of the query object to include a parameter from combobox.


My response:



Do not use VBA.

Use a reference to combobox in the Access query object.

If the dynamic parameter in query object does not work then there is something else seriously wonky about the query and no amount of VBA will help it anyway.

blinks... ok

[Ruegen]

Gasp*

It works.

I just referenced it to the form. I was hoping not to (in order to use the qry for other purposes) but if that is the only way then that is ok by me.

Thanks June