T. McConnell
Registered User.
- Local time
- Today, 17:01
- Joined
- Jun 21, 2019
- Messages
- 63
Ok, I am having a hard time getting this to work. I have seen numerous posts all over the Internet stating to use the below code. However when I place this code onto the Double click event, it opens to a blank record, but if I double click it again while the one form is still open, it will then display the correct record. Almost like I have to quad click it, which doesn't make no sense. Any suggestions?
Private Sub JobID_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmAdminOrders", , , "[JobID] = " & Me.JobID
End Sub
I have tried different variations of this code as well, but still no luck. As far as I can see the relationship links are setup correctly to use JobID as the link PK.
Thank you for any suggestions and help.
Private Sub JobID_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmAdminOrders", , , "[JobID] = " & Me.JobID
End Sub
I have tried different variations of this code as well, but still no luck. As far as I can see the relationship links are setup correctly to use JobID as the link PK.
Thank you for any suggestions and help.