I have a form that has a sub-form in datasheet view. On the sub-form is a text field named txtRecord. The field is a hyperlink. When the user clicks it I want a 3rd form to open to a specific record. \\Here is my onclick code of the hyperlink field but it is not working. Can someone assist?
DoCmd.OpenForm "frmLessons", acNormal, , "[ID]='" & Me.txtID & "'", acFormReadOnly, acWindowNormal