,
Somehow my bound comboboxes, do not dispaly the field content after navigating to another record. it seems to be a control level design problem, since the table data exists
I have done this so many times , and now i ve been dealing with this for hours, with no results
---------------
combo 1 : distritoID (NO problem)
after updating it requeries combo 2 : me.concelhoID.requery
combo 2 : concelhoID (some times OK, most of the time displays nothing)
after updating it requeries combo 2 : me.freguesiaID.requery
the control rowsource is :
combo 3 : freguesiaID (some times OK, most of the time displays nothing)
the control rowsource is :
--------------------
This should be something simple, but i cant see it. Any thoughts ?
Would it be OK to send a sample with he table and form ?
Somehow my bound comboboxes, do not dispaly the field content after navigating to another record. it seems to be a control level design problem, since the table data exists
I have done this so many times , and now i ve been dealing with this for hours, with no results
---------------
combo 1 : distritoID (NO problem)
after updating it requeries combo 2 : me.concelhoID.requery
combo 2 : concelhoID (some times OK, most of the time displays nothing)
after updating it requeries combo 2 : me.freguesiaID.requery
the control rowsource is :
Code:
SELECT tblConcelhos.ConcelhoID, tblConcelhos.Concelho
FROM tblConcelhos
WHERE (((tblConcelhos.DistritoID)=[Formulários]![Formulário1]![distritoid]));
combo 3 : freguesiaID (some times OK, most of the time displays nothing)
the control rowsource is :
Code:
SELECT tblFreguesias.FreguesiaID, tblFreguesias.Freguesia
FROM tblFreguesias
WHERE (((tblFreguesias.ConcelhoID)=[Formulários]![Formulário1]![concelhoid]));
--------------------
This should be something simple, but i cant see it. Any thoughts ?
Would it be OK to send a sample with he table and form ?