How to Restrict the Listbox on double click

[ganeshvenkatram]

Hi All



Im using list box with multiple fields in my access project and i have written code in listbox's double click event.

I have included column headers in the list box.

What im doing is im getting a list box field value when double clicking it and retreving datas from the table and filling in text boxes with that value.

For that " I should restrict such that i should not suppose to get the value if i double click on column header or Empty Rows in the List Box"

Plz tell the code to accomplish this.

[apr pillai]

When you Double-Click on the Header or Empty area of a listbox it returns Null Value. Check the returned value, if Null then Exit the Sub-Routine without taking any action.

Private Sub lstDat1_DblClick(Cancel As Integer)
   If IsNull([lstDat1]) Then
         Exit Sub
   End If
   DoCmd.OpenForm "MyForm", acNormal
End Sub

[ganeshvenkatram]

When you Double-Click on the Header or Empty area of a listbox it returns Null Value. Check the returned value, if Null then Exit the Sub-Routine without taking any action.

Private Sub lstDat1_DblClick(Cancel As Integer)
   If IsNull([lstDat1]) Then
         Exit Sub
   End If
   DoCmd.OpenForm "MyForm", acNormal
End Sub

Hi

Thanks for your reply.

Actually after clicking a record in list box, the selection focus goes to that record. Then after clicking the header row or empty row, the selection remains the prior selected record and that value alone is retrieving . Thats where im facing the problem.

Please Suggest.