What is wrong with this querry

[Mackooo]

I am trying to open a particular form with this query with

Private Sub listboxECN_list_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stCriteria As String

stDocName = "ECN_log"
stCriteria = "[ECN_number]= " & Me!listboxECN_list

DoCmd.OpenForm stDocName, , , stCriteria

ECN number is a number field in the data base.

My list box has two fiels ECN_number and Description but List box has only 1 bound column.
When I double click on the list box it opens the form but with the first record displayed only.

Please help.

Thanks in advance.

 

[efrank]

Is your data entry field set to yes on the form?

efrank

 

[Mackooo]

Thanks Efrank,

I checked it out and my filter for form was unchecked so I changed the form filter property to yes and it worked fine.

Thanks again.