ListBox Problem

[vilmarie]

HY: I modify a code that find in one page. I create a listBox in a form that contain the list of all the record that have my table "Information" I need that when I select one record in this list and click over this or over the button Show Record , open a form SL Data Entry with the information of this record. The problem is that when I open the form appear an error: The OpenForm action was canceled.


How I can resolve these?

The code is:


Private Sub ShowRecord_Click()
'Find a selected record, then close the search dialog box

DoCmd.OpenForm "SL Data Entry", , , _
"[Information.Number]=" & "'" & Me.lstSearch.Column(7) & "'"

'Close the dialog box
DoCmd.Close acForm, "prueba"

End Sub