combo boxes not displaying table values (1 Viewer)

[cpampas]

,
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 :

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 :

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 ?

 

[cpampas]

i started with a new form and controls, just in case something else was interfiering, but the problem persists. I attached a sample

 

[June7]

Comboboxes display descriptive alias, not the bound ID value and two of them are filtered by choices in other comboboxes. This is known as 'cascading comboboxes'. When combobox is filtered, some alias descriptions will not be available for display. This is a well-known issue of cascading comboboxes on continuous and datasheet form. Review https://www.access-programmers.co.u...g-the-second-column-when-not-selected.312773/.

 

[cpampas]

June,
Thanks for your help.
i added this to the current event of the form, wich did the trick

Me.concelhoid.Requery: Me.freguesiaid.Requery