SQL query for lookup rowsource for combo box doesn't show the first field requested

[pharmacologist]

I have a SQL query that populates a combo box from a few different fields but whichever field I list first after SELECT does not appear in the combo box.

Example:

SELECT [Cells].[Plasmid], [Cells].[CellType], [Cells].[CellID], [Cells].[FreezeDate] FROM Cells ORDER BY [CellID];

The Plasmid field does not appear in the combobox but the others do. If I remove the Plasmid field, then CellType no longer appears in the combo box. I have enough columns, e.g. I set it to 4 columns and the first 3 are populated by CellType, CellID, and FreezeDate, but the 4th column is empty.



edit: I'm an idiot. Column 1 width was set to 0

[orange]

Are the columns numbered from eg 0,1,2,3?
You'll have to post some code or a copy of the database if you need more assistance.
Readers need to see some of the details re your combobox, and related tables. Hopefully you are not using lookups in table fields.

Aside" your plasmid, cell and freezeDate brought this older post to mind.