The final push

[Mark12345]

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

[nico5038]

In a (datasheet/multiform) subform the combobox won't be seen as "individual" by Access. Only "bound" fields will work correctly :-(

In general you don't need to store the price in an orderdetail as you can always get the price from the Products table. Only when you need a "historical" price it's necessary. In such a case I use normally a "single row" subform for editing.

Nic;o)