Cannot open form by double clicking list box

[foxtet]

When double click the entries given in the attached database I cannot open the correct form. it gives parameter value.

kindly help me to overcome this error.

Fox

 

[bob fitz]

Show us the code in the Double Click event of the List box that attempts to open the form.

 

[foxtet]

Private Sub SearchResults_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frm_File_Info"

stLinkCriteria = "[FileNumber]=" & Me![SearchResults]

DoCmd.OpenForm "frm_File_Info", acNormal, , "FileNumber=" & Me.SearchResults.Column(1)


End Sub

 

[pr2-eugin]

Might be some problem with the Listbox properties. What is the Listbox RowSource, Bound Column, Column Count, Column Widths?

What is the type of the FileNumber field? Text or Number?

 

[JHB]

Private Sub SearchResults_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frm_File_Info"

stLinkCriteria = "[FileNumber]=" & Me![SearchResults]

DoCmd.OpenForm "frm_File_Info", acNormal, , "FileNumber=" & Me.SearchResults.Column(1)


End Sub

Replace the line with the below.

DoCmd.OpenForm "frm_File_Info", acNormal, , "FileNumber='" & Me.SearchResults.Column(0) & "'"