asked on
Referencing the combo box in the subform?
I am trying to requery for the combo box in another form.
I have two forms.
frmPublication/frmqryAffil
frmAuthor
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.[frm
I have two forms.
frmPublication/frmqryAffil
frmAuthor
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.[frm
Microsoft AccessVisual Basic ClassicVisual Basic.NET
Last Comment
mbizup
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I have it as AuthorID.
Can you upload a sample copy of your database, with any sensitive data removed?
ASKER
I check the subform name too, frmqryAffiliation Subform.
It is same.
It is same.
Create empty query, use builder to select your field (start from main form, then select subform), copy full name of field from query builder to VBA code
ASKER
OK. I got it fixed.
I used the macro to requery.
It was giving me that errror.
I changed it to the event code and it is working fine.
Why would macro error out though?
I used the macro to requery.
It was giving me that errror.
I changed it to the event code and it is working fine.
Why would macro error out though?
I ran into siomething similar in another question recently.
In that case it turned out to be a timing issue -- the Macro was getting executed before the subform was actually loaded.
With VBA, the timing of form/subform events is a lot more clear-cut.
In that case it turned out to be a timing issue -- the Macro was getting executed before the subform was actually loaded.
With VBA, the timing of form/subform events is a lot more clear-cut.