Rowsource Select * not returning all fields

[nanp]

I have a form with a search results list box and the search parameters are working great, but it's not returning all fields from the table. I used Select * so it should return all fields from the table I thought.



It's based on a single table. When I open the table itself, it has the field I'm looking for, but when I run the search on the form, it doesn't have the field.

lstSearchResults.RowSource = "SELECT * FROM vw_srch_NameByAddressInfo WHERE LastName LIKE '%" & sSearchText & "%' OR FirstName LIKE '%" & sSearchText & "%' OR Chapter LIKE '%" & sSearchText & "%' OR Company LIKE '%" & sSearchText & "%' OR City LIKE '%" & sSearchText & "%' OR State LIKE '%" & sSearchText & "%' OR Zip LIKE '%" & sSearchText & "%' OR Address LIKE '%" & sSearchText & "%' ORDER BY LastName,FirstName,MiddleName,Title,Chapter"

Any ideas where else I can look that's preventing the one field I really need from populating in the list box?

TIA

[Welshgasman]

Is the field count correct?
I would expect the query to be correct. Have you even looked at that?

[nanp]

Oh, I don't know. Forgive my stupidity, I don't know how to look for that. I'm still very new at all of this.

[Welshgasman]

Debug.print that sql when it has been populated with form values. Or just a simple select *.
Run the query string in the query sql window when the form is open with valid values.
Any control like combo or listbox needs the field count to match the number of fields in the source, if you want to make them available.

[Minty]

I would assume from the name that vw_srch_NameByAddressInfo is a linked SQL server view rather than a raw table?
Out of interest what is the name of the field that is missing?

[nanp]

Thank you. I will give that a go.

[nanp]

yes, it's a linked SQL server view. The field missing is NameChapterStatusID

[Welshgasman]

Actually called ColumnCount. Now back on my PC.

[pbaldy]

You may need to refresh the view:

https://www.mssqltips.com/sqlservert...-are-modified/