Double Clicking a List Box

[UT227]

I have a form [frmRptOfficerReport] with a list box [lstInvolvedPersons]. I want to double click the record on the list box and open a form where the second column equals the field in the form. I can't remember how to do that. This is what I tried, which just brought up the debugger:



Private Sub lstInvolvedPersons_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmRptSubjectORAdd", , , "[SubjectID]=" & Forms!frmRptOfficerReport!lstInvolvedPersons.Colum n(1)

End Sub

[UT227]

That put a space in it. Here it is:
DoCmd.OpenForm "frmRptSubjectORAdd", , , "[SubjectID]=" & Forms!frmRptOfficerReport!lstInvolvedPersons.Colum n(1)

[June7]

SubjectID is a number type? Why is it in the second column? What is in first column?

Could use shorthand Me.

DoCmd.OpenForm "frmRptSubjectORAdd", , , "[SubjectID]=" & Me.lstInvolvedPersons.Column(1)

Forum inserting space is a 'feature', can't edit it out. Ignore it.

[UT227]

Yes. It is a number type. I had the [ReportID] as the first column. The Me. worked. Thanks.