I am trying to populate a listbox from an access database using a left
join based on the value in a combobox. So if the ComboBox1.ListIndex1
= 1 then I want to retreive those records where FK = 1. My statement
is as follows:

statement = "SELECT tblPageLines.LineNum from tblPageLines LEFT JOIN
tblPages ON tblPageLines.FKPages = " & cbPages.ListIndex + 1

I am getting runtime error -2147217900 (80040e14): Join expression not
supported.

Do I have a syntax problem or is there something more?

Thanks,
Mike.