I am creating an ADO database with multiple forms to input the data. I am trying to pass a variable from Form 2 to Form 1 which I have done. But I would also like this to trigger a Private Sub on Form 1. How do I write this into code? Thanks for any help!

I don't think you can, as you have written this.

But if you put a hidden control on frmOne, and changed the value of that control, perhaps you could use the OnChange of the control as the triggered event, and the control’s value as the frmOne local “variable.”

can't you declare Public the sub in form1, something like

public sub PleaseCallMe()

so you can call it from form2: form1.PleaseCallMe

Another possibility is to add a public event in form2, and in form1 declare form2 withevents. Then in form2 just raise that event

Marco

Or you could do it if you changed the Public variable to a Public Property Let because then you could call the private sub from the Let sub.

Oooh! Good idea!
I totally forgot about the ability to add properties to forms.
I wish I had posted that!