Hi folks, thanks for looking.
My database takes down order details. But since I created a new price table, I cant get my add new order details subform to work.
I set the Add Oder Details Subform's, Rowsource for the Products combo to be:
SELECT DISTINCTROW Products.ProductID, Price.Price
FROM Products INNER JOIN Price ON Products.ProductID = Price.ProductID
WHERE (((Price.CustomerID)=[Forms]![Add an Order and details]![CustomerID]))
ORDER BY Products.ProductName;
In the After Update event of the control I put
Me.Price = Me.ProductID.Column(1)
Im now getting an error where the Add order details subform is not working, I keep getting an sql error saying value after end.
I know nothing of sql/vb, I checked all the forms in the VB window but could not find any data after the end sub.
I am in a real pickle here guys.
I look forward to hearing from you.
Regards
Mark
My database takes down order details. But since I created a new price table, I cant get my add new order details subform to work.
I set the Add Oder Details Subform's, Rowsource for the Products combo to be:
SELECT DISTINCTROW Products.ProductID, Price.Price
FROM Products INNER JOIN Price ON Products.ProductID = Price.ProductID
WHERE (((Price.CustomerID)=[Forms]![Add an Order and details]![CustomerID]))
ORDER BY Products.ProductName;
In the After Update event of the control I put
Me.Price = Me.ProductID.Column(1)
Im now getting an error where the Add order details subform is not working, I keep getting an sql error saying value after end.
I know nothing of sql/vb, I checked all the forms in the VB window but could not find any data after the end sub.
I am in a real pickle here guys.
I look forward to hearing from you.
Regards
Mark