Selecting distinct fields to display in Combo Box

[BlahBlahBlah]

This simple query doesn't show any items in a combo box, but does in datasheet view (5 distinct records, to be exact):

SELECT DISTINCT overview.[Risk Category]
FROM overview;

Apologies if I've neglected to post something that's required; it's Friday afternoon...

Cheers.

 

[MStef]

Maybe, put a BLANK in Row Source, SELECT DISTINCT......

 

[John Big Booty]

Try pasting your SQL into the Row Source as a single line of code;

SELECT DISTINCT overview.[Risk Category] FROM overview;

 

[Galaxiom]

What are the ColumnCount and ColumnWidths Properties (Format Tab)?
Should be:
1 for ColumnCount
Either nothing or some non-zero value for ColumnWidths.

 

[BlahBlahBlah]

Maybe, put a BLANK in Row Source, SELECT DISTINCT......

I'm not sure what you mean...

Try pasting your SQL into the Row Source as a single line of code;

SELECT DISTINCT overview.[Risk Category] FROM overview;

I made sure there were no returns and pasted it in again, but it's still showing up empty.

What are the ColumnCount and ColumnWidths Properties (Format Tab)?
Should be:
1 for ColumnCount
Either nothing or some non-zero value for ColumnWidths.

Ah hah! Awesome, thanks! The ColumnCount was 2 and ColumnWidths was 0cm;6.087cm so I changed it to just 6.087cm.