Listbox from dynamic SQL Query???

[J-F]

How can I populate a list box using an sql query using variables from 'option group' controls?

 

[Travis]

You populate the RecordSource Property with the SQL String.

This should refresh the List Box.

 

[J-F]

Many thanks.

 

[tehNellie]

Awise from the gwave!

I'm sure it's simple enough and I'm just [still] being dense, but right now I'm trying

strSQL ="SELECT somegubbins FROM sometable WHERE somecriteria ishappening"
me.lstListboxname.rowsource = strSQL
me.lstlistboxname.requery

Not chucking up any errors, not putting the SQL inthe rowsource or showing me any results either.

I knew there was a reason I tried to do as little as possible with forms

Any suggestions or pointers as to what I'm doing wrong appreciated.

[edit] I hate Access' fixation with brackets, the problem was in the query after all that, my bad.