I have two forms which I navigate back and forth between then viewing associated records. I use docmd.openform with the openargs being the ID of the record I want to goto. In the load event for each form I use this code to get to the record I need:
If Not IsNull(Me.OpenArgs) Then
Set rs = Me.RecordsetClone
rs.FindFirst "SDVN_NUM = '" & Me.OpenArgs & "'"
If Not rs.NoMatch Then
Me.Bookmark = rs.Bookmark
This works great the first time, however when both forms are opened the load event is not triggered and it does not perform navigation. I would like to solve this without having to close the forms in between calls. Just wondering how others handle this type of situation?