Hi Sir / madam,
I've encounter some issue. Hopefully you can teach me on how to resolve the issue.
In my listbox, there are 5 column.
If in the listbox "Status" column showing "Pending RCA" then open form A..
If in the listbox "Sattus" column showing "Pending Implementation" then open form B.
Any idea what is the coding?
Code:
Private Sub List2_DblClick(Cancel As Integer)
If List2.Column(5) = "Pending Implementation" Then <<< Something not correct here..but i donno what it is.
DoCmd.OpenForm "F2CAPAForm"
Forms!F2CAPAform!txtscar = Me.List2.Column(1)
Forms!F2CAPAform!txtscar.Enabled = False
Else
MsgBox ("wrong column")
End If