D
Don
I have a form with three tabs of which the first two have
subforms from queries. I'd like to requery one of the
subforms on tab 2 when a user selects it but am having
troubles getting it to work. I'd like to get the requery
to work first. Here is the code I've been trying:
Private Sub TabCtl35_Click()
Subform1 = "PUBLIC_CONCERN TAB2 Datasheet"
Me!Subform1.Form!PublicConcernNumber.Requery
End Sub
I'm new to Access so PLEASE feel free to give suggestions.
I'd then like to find if the requery could be attached to
the tab itself. Currently, I have to click inside the tab
area and not the tab part to get to the code. This
requires two clicks; one on the tab (to navigate there)
and one inside.
Thanks in advance!
subforms from queries. I'd like to requery one of the
subforms on tab 2 when a user selects it but am having
troubles getting it to work. I'd like to get the requery
to work first. Here is the code I've been trying:
Private Sub TabCtl35_Click()
Subform1 = "PUBLIC_CONCERN TAB2 Datasheet"
Me!Subform1.Form!PublicConcernNumber.Requery
End Sub
I'm new to Access so PLEASE feel free to give suggestions.
I'd then like to find if the requery could be attached to
the tab itself. Currently, I have to click inside the tab
area and not the tab part to get to the code. This
requires two clicks; one on the tab (to navigate there)
and one inside.
Thanks in advance!