Continuous form set value macro

  • Thread starter Thread starter Mary
  • Start date Start date
M

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
 
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
 
Back
Top