listbox problem

[akinia]

Hi,

I've created a custom menu with few controls.
One of these opens a form which retrieves data into a listbox.
This is done using VBA code ( lbo.rowsource="select..."), not from the listbox properties.
I get the results in the listbox but can't select any row.
The Locked property is set to NO and Enableb to Yes.

Any idea will be appreciated . ;-)

Thanks.

have a nice eday

 

[Crowley16]

I remember having a similar problem...

I can't remember the solution exactly though...

I think it's got something to do with the control source of the lbx, if the control source is referencing something that's not recognised by the query in the row source, you'd get something like that...

try playing with the names of the returned columns in your row source, or the bound values of the list box...

although I really don't know if this is the right answer or not...

 

[akinia]

Hi Crowley16,

I've found the problem.
To open the form from the menu I use a macro, and the data mode was read only.
Sorry I apologize for so a stupid thing. :-(


Thanks again.