unbound listbox can't select

[BrianMH]

Hi,

In access 2007 I have an unbound listbox on a form with a rowsource that is created using vba depending on certain searches. It lists the available searched items just fine but when I try to select an item in the list box I get text in the status bar "Control can't be edited; it's bound to unknown field 'Select...." that last bit is just the rowsource sql.

Any ideas what would be causing this?

Thanks

 

[BrianMH]

I resolved this. Even though it was unbound in its properties table I had accidentally set some controlsource instead of rowsource in my code.

 

[JakeJeon]

I resolved this. Even though it was unbound in its properties table I had accidentally set some controlsource instead of rowsource in my code.

Thanks! It solve my issue

 

[Treeivery33]

Could you share the code you used. I'm what I believe to be similar issue. I have a list of reports that I created on a table, however, I need some code to be able to select the reports.