I recently posted a question which was answered wonderfully. I wanted to update FieldA and then have FieldB autofill with a specific phrase. This was the result:
Private Sub FieldA_AfterUpdate()
Select Case Me.FieldA
Case Is = "Astro"
Me.FieldB = "06"
Case Is = "EPP"
Me.FieldB = "17"
Case Is = "CFSA"
Me.FieldB = "14"
End Select
However I now want to do exactly the same but FieldB will be on a subform. I am just unsure where I need to put the name of the subform to make this happen.
:banghead:
Any ideas?
Private Sub FieldA_AfterUpdate()
Select Case Me.FieldA
Case Is = "Astro"
Me.FieldB = "06"
Case Is = "EPP"
Me.FieldB = "17"
Case Is = "CFSA"
Me.FieldB = "14"
End Select
However I now want to do exactly the same but FieldB will be on a subform. I am just unsure where I need to put the name of the subform to make this happen.
:banghead:
Any ideas?