Column Designation error

Question

I have a list box (ERPNewOrderList) on a form (AddNewOrders). The rowsource for the list box is a query:

Column(0): SONo: [SalesOrderID] & "." & [SOLineNbr] where [SalesOrderID] datatype is ShortText and [SOLineNbr] datatype is Number LongInteger.

Column(1): [SalesOrderDate] datatype is Date/Time ShortDate.

 

After updating the list box, I am running a query that adds each item to a table (AddItTable), showing which items are selected and which are deselected:

INSERT INTO AddItTable ( SONo, Selected ) SELECT Forms!AddNewOrders!ERPNewOrderList.Column(0) AS Expr2, Yes AS Expr1 FROM AddItTable;

 

The query is not running. It gives the error:

What is the problem? How can I fix it?