Access Listbox

[SteveVS]

Hi all.
I require a bit of assistance with a list box

I populate the list box from a SQL query
the query works fine and the column widths are properly defined

But the problem is it doesn't show the "Description" of the first Row and none of the "Date" columns
But when I debug the code the "Date" column shows but not the "Description" column and this is only for a few records

[/IMG]

I would appreciate any assistance

 

[bob fitz]

Do you get the required results from the actual query if you open that

 

[SteveVS]

Yes I do get the correct results from the query when I run it

 

[bob fitz]

Have you tried to delete the combo box and recreate it

 

[SteveVS]

I have Tried that but still gives the same errors

 

[bob fitz]

Can you post a copy of the db

 

[The_Doc_Man]

You say it works correctly when you debug it. By that, do you mean that it works correctly if you take a breakpoint in the code, but not if you run straight through? If so, then focus on what follows that breakpoint.

 

[SteveVS]

It doesn't even correctly display with the break point. some rows only show the "date" and not the other fields while other rows show the other fields but not the "date" field

 

[SteveVS]

View attachment ListBox Error.zip
This is how the data is displayed
Unfortunately, I can't upload the DB