How can I update a query using VBA?

[thestappa]

I'm trying to update the SQL of my query via vba.



I'm trying to do that so I can have one query for a PIVOTCHART that I can just change the where clause on viewing. There doesn't seem to be a way to change the where clause when doing

docmd.openquery.

I figured I could just have a base query, grab the sql and add the where clause. I just can't seem to figure out how to take the new sql and save it to a different query.

Thanks

[pbaldy]

Well, you can use a DAO QueryDef object to change the SQL, but from what you've described, I would think you could just have a WHERE clause that pointed to a form where the user inputs their criteria. Unless you're actually changing which fields have criteria applied to them (and maybe even then), that's what I'd do.

[thestappa]

Well, you can use a DAO QueryDef object to change the SQL, but from what you've described, I would think you could just have a WHERE clause that pointed to a form where the user inputs their criteria. Unless you're actually changing which fields have criteria applied to them (and maybe even then), that's what I'd do.

I tried passing a where clause to a report (with chart) and was having a heck of a time getting it to work. Maybe I'll try that again.

I could get the chart to work no problem but the where clause wouldn't work.