I have a field on a form that opens another form on double-click with the following code:
When I edit the field in the form that pops up, frmLenderNotes, and exit, the record in the original form is missing the primary key and is no longer editable. If I do not edit the field and exit the form, this does not happen.Code:Private Sub Lender_DblClick(Cancel As Integer) DoCmd.OpenForm "frmLenderNotes", , , "[Job]='" & Me!Job & "'" End Sub