William Hindman
wdhindman at dejpolsystems.com
Mon Feb 2 09:47:33 CST 2009
Group ...this works fine lstFound.RowSource = "SELECT DISTINCTROW tblOrg.OrgID, tblOrg.OrgName, tblOrg.Address, tblOrg.City, tblOrg.StateOrProvince, tblOrg.Country, tblOrg.Buyer, tblOrg.Inactive FROM tblOrg WHERE (((tblOrg.OrgName) Like [txtSearchExpression]) And ((tblOrg.Buyer) = True) And ((tblOrg.Inactive) = False)) ORDER BY tblOrg.OrgName;" ...but when I try to concatenate 3 of the fields, I get a syntax error lstFound.RowSource = "SELECT DISTINCTROW tblOrg.OrgID, tblOrg.OrgName, tblOrg.Address, [tblOrg]![City] & ", " & [tblOrg]![StateOrProvince] & " " & [tblOrg]![Country]) AS CSC, tblOrg.Buyer, tblOrg.Inactive FROM tblOrg WHERE (((tblOrg.OrgName) Like [txtSearchExpression]) And ((tblOrg.Buyer) = True) AND ((tblOrg.Inactive) = False)) ORDER BY tblOrg.OrgName;" ...any help appreciated. William