I am trying to requery for the combo box in another form.
I have two forms.
When I adda new record in the frmAuthor, I want to requery the combo box in the subform of the frmPublication.
I don't see the control name for the combo box in the subform.
It is tied to the AuthorID so I am using the AuthorID as the controlID.
The subform has several textboxes to display the fields. I converted the textbox to a combo box.
How can I reference the combo box of subform in another form?
There is no field named "Forms!frmPublication.[frmqryAffiliation subform].Form.AuthorID in the current record.