Configuring my form

[Mark12345]

Hi guys I have a database that takes orders and prints an invoice & Work Order
Each customer has there own price list which is in the customer table.
I have put the raw source for In your AddOderDetailsSubform the Rowsource for the Products combo is like so:

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;

This should list the products for the Customer selected for the Order.
In the After Update event of that control put

Me.Price = Me.ProductID.Column(2)

What happens is the add new order form is not working.
When accessed the db brings up search criteria for several fields.
It doesnt bring up my product

Thanks
Mark

[nico5038]

Did you try:
Me.Price = Me.ProductID.Column(1)
The columns are "zero based"

Nic;o)