Populating text box with value from list box troubles

[BlueJacket]

I'm not sure why this is happening.

I have a listbox that is displaying six fields: Client, County, Street Number, Street Name, Case Number, and Judge Name. The row source of the list box also has many other fields that are not displayed, some of which are dates.

Row Source:

SELECT qryMainSearchAll.Client, qryMainSearchAll.CountyID AS County, 
qryMainSearchAll.StreetNumber AS [St Num], qryMainSearchAll.StreetName AS [Street Name], 
qryMainSearchAll.CaseNumber AS [Case Number], qryMainSearchAll.JudgeName AS [Judge Name], 
qryMainSearchAll.PropertyID, qryMainSearchAll.RipenDate, qryMainSearchAll.PaperworkSentDate,
 qryMainSearchAll.ResponseDeadlineDate, qryMainSearchAll.AmountReceived FROM 
qryMainSearchAll ORDER BY qryMainSearchAll.Client, qryMainSearchAll.CountyID;

In my text box, I have

=[lboMainSearchResults].[column](7)

And it returns nothing. Columns 1-6 work, but it stops working at 7.

Thank you in advance.

 

[sneuberg]

What is the Column Count property of the listlbox set to? I think it needs to be at least 8.

 

[BlueJacket]

Yup. That was it. So simple. Thank you.