parameter for query

[Howard Brody]

Depends on the type of query you're trying to run.

If it's an Append, Delete, Make-Table or Update query, I
just build the SQL string in VBA and use the DoCmd.RunSQL
command . . . except that dosn't work for Select queries.

I've done this a couple of times. You still need to build
a SQL string but then use the CreateQueryDef method (check
the Help files for the details) for saving it as a query
in your db. Then you can run it.

Hope this helps!

Howard Brody