Hello Richard,
I have a form that has a listbox which I try to fill with the selection made by drilling it down by selecting from a couple of textboxes.

the comand is:
TopWijnLijst.RowSource = "SELECT etc"
which is triggerd by clicking a command button.

Yes, I stole the SQL from a query. but since the TOP Values cannot be part of the query command the "peanuts" can build (no field for in the query). I had to add the "TOP 25" after the "SELECT " as Access does too.

Problem I run into when pasting this line of SQL into the VBA-code of the SelectButton: (due to translation it could be not exactly, hope you understand)
"compile error: expecting end of instruction"
Running it from the Form:
"Compile error:  syntax error"
After trying to cut the lines with your normaly funtioning &_ or _:
In the second line of code starting now with the FROM clause:
"Compile error: expected )" on the first INNER - which I do not understand at all.

Whatever I try this last message keeps poppin up.

Thanks for looking into this,

eddy "peanut"