ListBox Updating from ComboBox

[mcleester]

I have created a ListBox with the following rowsource:

SELECT a.fname+' '+a.lname AS Expr1
FROM Titles AS T, authors AS A, title_auth AS TA
WHERE (((T.titleID)=forms!test!TitleComboBox) And ((TA.authorID)=a.authorID)
And ((T.titleID)=ta.titleID));

I also have the following code:

Private Sub TitleComboBox_Change()
AuthorListBox.Requery
End Sub


When I change the TitleComboBox, the query works. However, I can't see the
results of the query in the listbox. I can see that there are one or two
authors depending on the title selected (I can select only one or scroll
between two blank options).

When I put a break in the code, I can actually see that the correct
selections are there (using the authorlistbox.value property as a watch).

Yet they are not VISIBLE. I have checked the font colors and silly stuff
like that. I think I am missing some kind of event.

 

[mcleester]

The problem was the "column widths" property. For some reason, it thought I
had two columns. The first one was zero length.