Hi All,
Initially when i write the coding no issue, but not sure why suddenly the error comes out. Anyone can help me on this?
Code:Private Sub List2_DblClick(Cancel As Integer) If List2.Column(5) = "Pending_RCA" Then DoCmd.OpenForm "F2CAPAform" Forms!F2CAPAform!txtscar = Me.List2.Column(1) Forms!F2CAPAform!txtscar.Enabled = False DoCmd.Close acForm, Me.Name End If End Sub