Passing data from one record to a control in a new record

[instructor]

I have a subform that I would like to pass the contents of one control to a new record. I tried:

Private Sub form_Afterupdate()
     Dim ctl as Control
     For Each ctl in Screen.ActiveForm.Controls
          If ctl.Tag = "Carry" Then
               Ctl.DefaultValue = """" & ctl.Value & """"
          End If
     Next
End sub

I then set the correct control's tab to "carry." But, it doesn't work.

Any ideas??

[Seth Schrock]

I'm not exactly sure what you are trying to do and what the situation is, but my guess is that your code isn't getting triggered. The form's After_Update event is run after the a record is updated, not after a property of a control is changed. My suggestion would be to create a button and put your code in the On_Click event and see what that does.

[instructor]

That did it! Thank you.

[instructor]

Thank you! That accomplished what I wanted.

[Seth Schrock]

Glad to be able to help. Good luck on your project.