Rowsource through VBA is broken?

[Nick via AccessMonster.com]

I'm losing it here and I need some help...

I need to dynamically set the rowsource for a combobox on Form_Load; I
created a Select query and grabbed the SQL with intent to modify so it would
be dynamic. I ran the query, and got the result I was looking for... when I
pasted the code to test and set the RowSource equal to it in VBA, it shows
nothing.

Is this not the correct rowsource code?
Me.cbAvailableKits.RowSource = strQuerySQL
Me.cbAvailableKits.Requery

My actual SQL statement is as follows:
SELECT [Tbl - Mod Kits Progress].Unicode FROM [Tbl - Mod Kits Progress] INNER
JOIN [Tbl - Step Definitions] ON [Tbl - Mod Kits Progress].[ID Step] = [Tbl -
Step Definitions].[ID Step] WHERE ((([Tbl - Step Definitions].Number)=4) AND
(([Tbl - Mod Kits Progress].[To Be Modified])=True));

However, seeing as that works perfectly in a query, I don't know what the
problem is... any help would be greatly appreciated.

-Nick

 

[Nick via AccessMonster.com]

Good thing I posted... it took another 5 minutes to answer myself.

But for anyone who was wondering... Remember to set your RowSourceType to
"Table/Query". I had inadvertently deleted it and forgot to reset it.