Listbox programming

[onlylonely]

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?

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

[June7]

Reference columns by index. Index begins with zero so column 5 is index 4.

List2.Column(4)

[onlylonely]

Reference columns by index. Index begins with zero so column 5 is index 4.

List2.Column(4)

I've tried List2.Column(3) ,4,5,6 still not able to get.

Private Sub List2_DblClick(Cancel As Integer)


If List2.Column(5) = "Pending Implementation" Then


DoCmd.OpenForm "F2CAPAForm"

Forms!F2CAPAform!txtscar = Me.List2.Column(1)


Forms!F2CAPAform!txtscar.Enabled = False


Else


MsgBox ("wrong column")


End If

Any idea?

Thank You,
Regards,
tonyshieh

[June7]

Why does a space show in front of " Pending RCA"?

Exactly what is the issue - error message, wrong result, nothing happens?

If you want to provide db for analysis, follow instructions at bottom of my post.

[onlylonely]

Hi June,

Because of the space, it wasted my time. Stupid me.
Thanks for teaching