AgentSmith
New member
- Local time
- Today, 17:13
- Joined
- Sep 8, 2014
- Messages
- 2
SOLVED Requery Control on Subform from Main Form
Hello.
I have a form called Add New Delgation, i have combo box of Institution names on the main form and a subform for Agreements discussed. with a combo box called agreements. I successfully cascaded the combo boxes so that the agreements discussed on the subform are filtered by their respective institutions on the main form. However i am unable to refresh the list each time a new institution is selected as the Macro will not allow me to requery a control on the mainform from the subform.. I would appreciate any help. I am able to use basic VBA code if i could be provided with one.
Thanks again in advance.
Juan
Hello.
I have a form called Add New Delgation, i have combo box of Institution names on the main form and a subform for Agreements discussed. with a combo box called agreements. I successfully cascaded the combo boxes so that the agreements discussed on the subform are filtered by their respective institutions on the main form. However i am unable to refresh the list each time a new institution is selected as the Macro will not allow me to requery a control on the mainform from the subform.. I would appreciate any help. I am able to use basic VBA code if i could be provided with one.
Thanks again in advance.
Juan
Last edited: