vba syntax to open form from a subReport

[mainerain]

On frmMainMenu I have srptFollowup (subReport).
srptFollowup has btnEditEvent.



I want to open frmEvents on btnEditEvent Click Event to the specific record

Private Sub btnEditEvent_Click()
         DoCmd.OpenForm "frmEvents, acNormal,, "[EventsID] = ????? [EventsID]"

End Sub

[Minty]

What is the control called that holds the [EventID] on the subform?

Private Sub btnEditEvent_Click()
         DoCmd.OpenForm "frmEvents, acNormal,, "[EventsID] = " & Me.YourControlNameGoesHere
 End Sub

[mainerain]

That did it! Thanks.

Can you describe the WHERE clause syntax?

Private Sub btnEditEvent_Click()
         DoCmd.OpenForm "frmEvents, acNormal,, "[EventsID] = " & Me.EventID
 End Sub

[Minty]

Certainly - It is a string expression but you need to concatenate the value from the control(s) on your form into the string.
So if you where to do this a little more "expanded" you could see the expression a little more clearly;

Private Sub btnEditEvent_Click()
    
    Dim strWhere       as String
    
    strWhere = "[EventsID] = " & Me.EventID       
    Debug.Print "Your String is : " strWhere 

    DoCmd.OpenForm "frmEvents, acNormal,, strWhere

End Sub

If you open the immediate window in the VBA Editor (Press Ctrl + G) you will see the result of the Debug statement.
This is a great way of handling this type of expression as you can easily see what is being passed to the open form command.

Debugging you code in this way can easily show up errors and what is really happening, as opposed to what you "think" is happening...

[mainerain]

Thanks so much Minty! Another tidbit for my education.

Learning Access and all it's workings has been very rewarding and very frustrating. Typically the rewarding comes after the frustrating

[Welshgasman]

Typically the rewarding comes after the frustrating

Made all the more sweeter though?