João serras-pereira
asked on
subform does update on ms/access
I have a "framing" form where I have a control that, when changed, its contents change the "where" clause of a query. They do, and when I review the query, it is OK - the correct set of records is there. This query is the data source of a subform, that should show the set of selected records.
However, even though I use the "requery" method:
strSetSQL = "SELECT tabancasBase.codigoTabanca , tabancasBase.NomeTabanca, tabancasBase.Programa, tabancasBase.habitatTabanc a, tabancasDemografia.projPop 2014, ticketCA.fechoTicket, regioesGuineBissau.nomeReg ia, sectoresGuineBissau.nomeSe ctor, tabancasBase.codigoSector "
strSetSQL = strSetSQL & "FROM ((regioesGuineBissau INNER JOIN sectoresGuineBissau ON regioesGuineBissau.codigoR egiao = sectoresGuineBissau.codigo Regiao) INNER JOIN (tabancasBase LEFT JOIN ticketCA ON tabancasBase.codigoTabanca = ticketCA.codigoTabanca) ON (sectoresGuineBissau.codig oSector = tabancasBase.codigoSector) AND (regioesGuineBissau.codigo Regiao = tabancasBase.codigoRegiao) ) LEFT JOIN tabancasDemografia ON tabancasBase.codigoTabanca = tabancasDemografia.RefTaba nca "
strSetSQL = strSetSQL & " WHERE (((sectoresGuineBissau.cod igoRegiao) ='"
strSetSQL = strSetSQL & Me.fld_regiao & "'));"
Set Q44_selectTabancaDef = sireshDB.QueryDefs("Q44_se lectTabanc a")
Q44_selectTabancaDef.SQL = strSetSQL
Set Q44_selectTabancaSet = sireshDB.OpenRecordset("Q4 4_selectTa banca", dbOpenDynaset)
Me.[sform_listaTabancas].F orm.Requer y
can anyone help?
However, even though I use the "requery" method:
strSetSQL = "SELECT tabancasBase.codigoTabanca
strSetSQL = strSetSQL & "FROM ((regioesGuineBissau INNER JOIN sectoresGuineBissau ON regioesGuineBissau.codigoR
strSetSQL = strSetSQL & " WHERE (((sectoresGuineBissau.cod
strSetSQL = strSetSQL & Me.fld_regiao & "'));"
Set Q44_selectTabancaDef = sireshDB.QueryDefs("Q44_se
Q44_selectTabancaDef.SQL = strSetSQL
Set Q44_selectTabancaSet = sireshDB.OpenRecordset("Q4
Me.[sform_listaTabancas].F
can anyone help?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER