Combo box wont work after upsizing to SQL

[morlan]

I originally had an normal access database and then I split in to SQL and an ADP file.

I have a combo box on my form that looks to the SalesExec table and puts the Forename and Lastname into one column in the combo. The row source looked like this:

SELECT tblSalesExec.EmployeeID, [tblSalesExec.Forename] & " " & [tblSalesExec.Surname], FROM tblSalesExec ORDER BY [Forename];

Now, after converting to SQL/ADP using the upsizing wizard, when I click on the combo box I get the following error: Invalid column name

The row source had changed to this:

SELECT tblSalesExec.EmployeeID, "tblSalesExec.Forename"+' '+"tblSalesExec.Surname", FROM tblSalesExec ORDER BY Forename;

Any adise? The tables are definatley available? IS there something I have to do to the row source to get this working?

 

[morlan]

^ bump

 

[morlan]

SELECT tblSalesExec.EmployeeID, "Forename"+', '+"Surname" FROM tblSalesExec ORDER BY Forename;

is the correct answer