J
jacchops
Previously I had a form that combined information from a couple different
tables. This form was long, and whenever the users used their scroll button
to scroll down the form, the records would cycle as opposed to the form
scrolling.
So instead of using one long form, I am designing a new form with a tab
control and a subform on each tab.
When a user selects "Yes" from the drop-down of Contol 1 in Subform 1 on Tab
Page 1, I want value of Control 2 in Subform 2 on Tab Page 2 to automatically
to be set to "N/A" (which is an option in the drop down for Control 2).
Previously, when Control 1 and Control 2 were on the same form, I had a
"Select Case..." VB code for the After Update event procedure for Control 1
that looked like this:
Select Case Control_1.Value
Case "Yes"
Control_2.Value = "N/A"
End Select
How do I do this when Control 1 and 2 are on different subforms?
tables. This form was long, and whenever the users used their scroll button
to scroll down the form, the records would cycle as opposed to the form
scrolling.
So instead of using one long form, I am designing a new form with a tab
control and a subform on each tab.
When a user selects "Yes" from the drop-down of Contol 1 in Subform 1 on Tab
Page 1, I want value of Control 2 in Subform 2 on Tab Page 2 to automatically
to be set to "N/A" (which is an option in the drop down for Control 2).
Previously, when Control 1 and Control 2 were on the same form, I had a
"Select Case..." VB code for the After Update event procedure for Control 1
that looked like this:
Select Case Control_1.Value
Case "Yes"
Control_2.Value = "N/A"
End Select
How do I do this when Control 1 and 2 are on different subforms?