I have tried to apply this code to a button as an 'On Click' Event. But I keep getting an error message saying it expect an end statement. The code works if I run it through a regular query but I want to be able to manulipulate the data more easily with a combo box.

ProductList.RowScouce =

SELECT AddressDirectoryT.AddressID, IndividualxGroupT.GroupID, IIf([FirstName],[FirstName] & " " & [LastName],[CompanyName]) AS Contact
FROM AddressDirectoryT INNER JOIN IndividualxGroupT ON[ AddressDirectoryT.AddressID = IndividualxGroupT.AddressID];

End Sub

Jim O

---

Reply from Richard Rost:

It's probably the bracketing of your join field names. You'd need brackets around EACH field. Also, if possible, I don't like to put functions in my SQL statements. Almost always better to create a helper query with the function then use THAT query for your SQL statement data source.