I am having problems with the combo box. Basically, I have two tables. One is the Products table: "ProductID", "Title", "Price" and the other table is OrderDetails: "OrderDetailID", "ProductID", "Quantity", "Price". How would I be able to have the user select a Title (which is a combo box) which would automatically populate the Price text box in the OrderDetails form? Any help is appreciated. Thank you!

There are examples of how to do this in northwind.mdb and solutions.mdb