changing show button in VBA

[Ssstacey]

Hi,
I want to be able to change the 'uncheck' and 'check' the show button in a queryfilter in VBA? Does anyone know the code/command for this?
Thank you..
Stacey

 

[KenHigg]

I would think the best way would be to build the query the way you want it, then copy the sql string it generates and use it where you need in stead of the pre-built query. Then using that query, uncheck (or change) the view option in the query builder and then use the new sql string where you need...

Or simply use two pre-built querys...

 

[Ssstacey]

Thanx.. I will try to implement it like that..