Trying to auto-update subform price once the subform product selected. The price is to be fetched from the product form. Going crazy as this code is taken from a ZC blog and cant see why it doesnt work. ZC doesnt recognise the phrase "row" ??
//Fetches the information from the "Products" table
selected_Product = Productsform [Product_Name_Field = row.Order_Item_Name];
//Updates the value of Unit Price using the stored value from "Products" table
row.Order_Item_Price = selected_Product.Product_Price_Field;