Columns in Combo Box

[ss2020]

I have form with an unbound combo box based on a query. The query has to fields. The combo box has the # of columns set to 2 but only the first column displays the data, the 2nd column is empty. I have the column widths 1",1". Not even the column head shows in the 2nd column. Can anyone help?

Thanks.

[John_G]

Did you try running the query by itself to make sure it is correct? It sounds as if the query only has one column (field), particularly since the second column in the combo box has a blank heading. I was able to get the same results you describe by making a combo box with more columns than its query did.

[ss2020]

Yup, it runs great. I see just what I expect to see, 2 columns of data. I am not sure if it should matter in this case but the 2 fields are 1 table and a 2nd query that is related. I mention it for completeness.

[June7]

Want to provide the project for analysis?

[ss2020]

All fixed, it was my select statement that column was not pulled. Sorry to have bothered anyone.