Solved After update combobox on subform

[tihmir]

Hi all,
I have a form "FormA" with 2 comboboxes - cboMunicipality and cboCity. The cboMunicipality on Event After Update hase Me.cboCity.Requery. The cboCity on Event Row Source on Build has 2 tables :

SELECT tbl_Cities.City, tbl_Municipalities.Municipality
FROM tbl_Municipalities INNER JOIN tbl_Cities ON tbl_Municipalities.MunicipalityID = tbl_Cities.MunicipalityID
WHERE (((tbl_Municipalities.Municipality)=[Forms]![FormA]![cboMunicipality]));

[Forms]![FormA]![cboMunicipality] - this is in my Criteria on tbl_Municipalities
When I try to use this form "FormA" as subform my cboCity not works and show my Enter Parameter Value ? Forms!FormA!cboMunicipality
What do I need to change to be able to after update the cboCity ?

 

[pbaldy]

This should help:

Forms: Refer to Form and Subform properties and controls

www.theaccessweb.com

 

[tihmir]

This should help:
Forms: Refer to Form and Subform properties and controls

Thanks,pbaldy. I looked through the table, but I can't figure out how to do it. Is it possible to illustrate with an example to make it clear , please?

 

[pbaldy]

This is the syntax you're after:

Forms!Mainform!Subform1.Form!ControlName

 

[tihmir]

This is the syntax you're after:
Forms!Mainform!Subform1.Form!ControlName

Until I found the right place to put the syntax........, it was a big mess!.....(build, Criteria... build, Criteria, build, Criteria). Finally I did it! I will definitely remember this lesson!
Тhank you very much, pbaldy!

 

[pbaldy]

Happy to help!