Basic listbox question open form on click but second id value in 2nd column

[Ruegen]

I have a listbox which displays performers bookings as well as the schools attached and it includes the id of the performer and the id of the school in the first two columns

I would like to open a form when you double click the booking however I can't get it to relate.

Private Sub lstBookings_DblClick(Cancel As Integer)


DoCmd.OpenForm "frmSchoolsFound", , , [NewSchoolsID] = [NewSchoolsID]

End Sub

DoCmd.OpenForm "frmSchoolsFound", , , "NewSchoolsID=" & [NewSchoolsID]

and

DoCmd.OpenForm "frmSchoolsFound", , , me.lstBookings.Column(2) = [NewSchoolsID]



don't seem to work either.

Form opens but not to the correct record.

[Ruegen]

Never mind answered my own

DoCmd.OpenForm "frmSchoolsFound", , , "[NewSchoolsID]=" & Me.lstBookings.Column(4)

moved the column and put it at .001cm;