MS Access how can a subform get the value from another subform?
I have a main form that contains two other child subforms. When a textbox value changes on subform (A) I would like to set the value of a textbox on subform (B) equal to the changed textbox on subform (A).

So being completely new to Access I did some googling and it looks like this can accomplish this with some VBA. So on subform (A)'s textbox  'after update' event I have added this VBA.

    Private Sub ID_AfterUpdate()
        Me.Parent.Forms.formA.textboxDestination.Value = Me.textboxSource.Value
    End Sub

I am doing this using the code builder. Then I save and run the form. Nothing happens. No errors.. nothing I am not even sure that piece of code is running. I'm not even sure how one debugs VBA in Access. Can someone help me out?

Thanks!
  
MS Access how can a subform get the value from another subform?
===

I have a main form that contains two other child subforms. When a textbox value changes on subform (A) I would like to set the value of a textbox on subform (B) equal to the changed textbox on subform (A).

So being completely new to Access I did some googling and it looks like this can accomplish this with some VBA. So on subform (A)'s textbox  'after update' event I have added this VBA.

    Private Sub ID_AfterUpdate()
        Me.Parent.Forms.formA.textboxDestination.Value = Me.textboxSource.Value
    End Sub

I am doing this using the code builder. Then I save and run the form. Nothing happens. No errors.. nothing I am not even sure that piece of code is running. I'm not even sure how one debugs VBA in Access. Can someone help me out?

Thanks!
  