Having a gey moment ... attempting to fix a broken database with recovered queries and data.
A query which references form fields is not binding to a list control in the forms design mode
SELECT tablename.tablefield
FROM tablename
WHERE tablename.tablefield2 = ([forms]![thisformsname].[formfield]);
I am thinking this is probably a good thing because there are several list objects each dependant on the previous selection ... so I have set the list control to UNBOUND ... is there an easy or recommended way to bind the query to the unbound control on condition from code so it can be requeried as required???
I am thinking that there must be a way to use a DAO object (container) and dynamically bind it to the list's object container?
The hard/slow way is to delete the all list elements then add all elements from the query container one at a time.
A query which references form fields is not binding to a list control in the forms design mode
SELECT tablename.tablefield
FROM tablename
WHERE tablename.tablefield2 = ([forms]![thisformsname].[formfield]);
I am thinking this is probably a good thing because there are several list objects each dependant on the previous selection ... so I have set the list control to UNBOUND ... is there an easy or recommended way to bind the query to the unbound control on condition from code so it can be requeried as required???
I am thinking that there must be a way to use a DAO object (container) and dynamically bind it to the list's object container?
The hard/slow way is to delete the all list elements then add all elements from the query container one at a time.
