Rowsource through VBA is broken?

  • Thread starter Nick via AccessMonster.com
  • Start date
N

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
 
N

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top