Hi folks, thanks for looking. I have a database that takes down order details.
I Since creating my Price table I cannot acces the add order details subform to choose my products, and there prices.
I set the AddOderDetailsSubform'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(2)
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 and will be on here all night till I sort it.
I look forward to hearing from you.
Regards
Mark
I Since creating my Price table I cannot acces the add order details subform to choose my products, and there prices.
I set the AddOderDetailsSubform'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(2)
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 and will be on here all night till I sort it.
I look forward to hearing from you.
Regards
Mark
Last edited: