I put a double click event so that when you click on a name, it takes the user to the form on which the name is located. Now I tried to use that same on in a different place and it is returning an error. It works elsewhere just not here. See code and attached database.
Private Sub Policy_Name_DblClick(Cancel As Integer)
DoCmd.SearchForRecord acDataForm, "Contact Form", acFirst, "[ContactID] = " & Nz(Me.ContactID, 0)
Me.Parent.TabCtl0 = 1
This code works on the copy of actions and opps subform. But it does not work on expiring in 7 days subform. WHen I double click the policy name in the expiring in 7 days subform is throwing an error.
See the contact form and go to actions tab and you can try it there.