Continuous form set value macro

[Mary]

I have a worklist form where users can view tickets assigned to them. I would
like the user to be able to double-click the [Event_Name] field to take them
to [combo1] on form [OA_home]. OA_home is set up where the user selects an
event from combo1 to find that record.

DoCmd.OpenForm "OA_home", acNormal, "", "", , acNormal
Forms!OA_home!Combo1 = Forms!MyEvents!Event_Name
DoCmd.Close acForm, "MyEvents"

It opens OA_home and closes MyEvents, but it doesn't set the value for
combo1 or fire the on change event. Can you help?

Thank you!
Mary

 

[Mary]

I've also tried this code from another post - still not updating the combo1
field.

Dim intCopyNum As String
intCopyNum = Me.Event_Name.Value
'copy value into memory
DoCmd.OpenForm "oa_home", acNormal
'open the other form
Forms![OA_home].Form.[Combo1].Value = intCopyNum
'Paste the value into the 2nd form's control
DoCmd.Close acForm, "MyEvents", acSaveNo