Create a query in VBA, Access 2007

[laavista]

I need to create a query in VBA. I'm using Access 2007.



I have a combo box and based on the user's selection(s), a 'where clause' is created. I need to either create a query that includes my where clause, or use an existing query and use the where clause.

I had created a query in VBA in Access 2003 using DAO defs, e.g.,
set qdef = MyDB.CreateQueryDef("q_regions", strSQL)
This does not work in 2007.

Any suggestions would be greatly appreciated.

[NTC]

generic advice to all struggling in making a vb based query.....set it up using plain ole query design - - and then use the SQLview feature to see the syntax...which you can copy over to your vb statement with only minor syntax changes....

[laavista]

Thanks for the advice.

I just solved this. I was attempting to use DAO, but Access 2007 does not use it.

[pbaldy]

Not clear what you mean with that last statement. You can certainly use DAO in 2007.