ListBox column is null

[soulice]

I have a listbox filled form a query. It has 4 columns. I want the value from the last column and use it to open a report. I can open a report ok, the issue is that
Me.lstThings.Column(3) is always null. Read a stack of posts out here and appear to be doing it right. What am I missing?

 

[spikepl]

How exactly did you determine that that value is null? And what is the column count of the listbox?

 

[soulice]

I am debugging, then stepping through. ColumnCount comes out to 4.

 

[vbaInet]

Did you select a row in the listbox before calling the code?

 

[soulice]

Yes, I am doing this on the DblClick action...

 

[vbaInet]

Try it on the Click event. If you're not having luck upload a cutdown version of your db so we can see what you're doing.

 

[pr2-eugin]

Does your line of code look something like this??

Me.lstThings.Column(3, lstThings.ItemsSelected)

 

[soulice]

Here it is:
DoCmd.OpenReport "IndividualReport", acViewPreview, , "[IndividualReport_ID]= " & Me.lstThings.Column(3, lstThings.ItemsSelected)

returns null on DblClick. OnClick does nothing.

 

[boblarson]

ItemsSelected requires an INDEX

Me.lstThings.ItemsSelected(x)

where x is the row.

If you don't have it set to be multiselect then you can just refer to the column

"[IndividualReport_ID]=" & Me.lstThings.Column(3)

If your list box is multiselect then you would not be able to do it this way anyway so you would need to iterate through the ItemsSelected to build an IN Clause.

 

[soulice]

Multiselect is set to none. I must have another setting wrong as Me.lstThings.Column(3) is Null as well. I would like to post a sample db, but it has too much proprietary stuff to trim it down and post.

Edit: just noticed (not sure why I didnt see this before) that when I select any row, it is not acutally selecting the row. The first row appears to get focus, but always returns null.

 

[soulice]

Fixed it. I had the listbox bound to a field. Once I removed the binding, all was well. Thanks all. Be back shortly with more questions!