Best Way to Dynamically Alter the Select List of A Query

With respect to my earlier post, I am trying to find the best way to
dynamically alter the select list of a query.
Any suggestions!!
Cheers
--
Regards

Ashley Smart

Ashley

Answered in your earlier post.

Another (BUT MUCH CLUNKIER) approach would be to build as many different
queries as you would need for any/all combinations of choices on your form.
Then, in code behind your form, values in fields would be tested to
determine which query to run. CLUNKY! INELLEGANT!

Regards

Jeff Boyce
Access MVP


"A. Smart" wrote in message
...
With respect to my earlier post, I am trying to find the best way to
dynamically alter the select list of a query.
Any suggestions!!
Cheers
--
Regards

Ashley Smart

I do this all the time in code simply by altering the SQL of the querydef,
like this...

Function ModifyQuery(sQueryName As String, sSql As String) As Boolean
On Error GoTo Err_ModifyQuery

Dim dbModify As DAO.Database
Dim qdfModify As DAO.QueryDef

Set dbModify = CurrentDb
Set qdfModify = dbModify.QueryDefs(sQueryName)
qdfModify.sql = sSql

ModifyQuery = True

Set qdfModify = Nothing
Set dbModify = Nothing

Exit Function
Err_ModifyQuery:
ModifyQuery = False
Err.Raise Err.Number, Err.Source, Err.Description
End Function


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200509/1