Errors when adding Combo Box

[jwr]

I have a subform which has a field with a combo box. I want to change the
combo box to another field on the form.

I have changed the original combo box to a text box and created a combo box
for the desired field.

When I do this, I now can no longer enter info into the first field of my
form, but if I go past it, I get message that it does not have info in
Dealer table. I did not change any field except the two boxes. Below is
the SQL from my form:


SELECT DISTINCTROW [Order Details].OrderDetailID, [Order Details].OrderID,
[Order Details].LineItem, Products.ProductName, [Order Details].SerialNum,
[Order Details].Quantity, [Order Details].UnitPrice, [Order
Details].Discount, Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2) AS [Line Total], Products.ProductCode,
[HandlingPct]*Round([Quantity]*[Order Details].UnitPrice*(1-[Discount]),2)
AS HandlingChg
FROM Products INNER JOIN [Order Details] ON Products.ProductID = [Order
Details].ProductID
ORDER BY [Order Details].LineItem;

Thank you,
Joy

 

[jwr]

I just realized that I did not give you both of my SQL views:

This one works:

SELECT DISTINCTROW [Order Details].OrderDetailID, [Order Details].OrderID,
[Order Details].LineItem, [Order Details].ProductID, [Order
Details].SerialNum, [Order Details].Quantity, [Order Details].UnitPrice,
[Order Details].Discount, Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2) AS [Line Total], Products.ProductCode,
[HandlingPct]*Round([Quantity]*[Order Details].UnitPrice*(1-[Discount]),2)
AS HandlingChg, [Order Details].Notes
FROM Products INNER JOIN [Order Details] ON Products.ProductID = [Order
Details].ProductID
ORDER BY [Order Details].LineItem;

The one below does not work.
The one difference I see is the change from Product ID to Product Name.