You know what... I should have watched just a few minutes further. The idea of setting a default value in the combo box is BRILLIANT I had no idea you could do that. The app I'm working on now is similar to the Inventory app except that Orders and Order Details forms are combined as form and subform respectively, and the orders form also has a combo box that you can select a customer by manually. I still have a separate customers form, but clicking on the Orders button opened the Orders form but never went to the customer.

The only thing I have yet to solve is that since Order Details is a SUBFORM of the Orders form, it's tough to get the order total (which I store in the orders table) to update the same way Rich as it in the Inventory video, since that order total is not just on the order lines form, but also on the parent form and I can't get the two to talk to each other.

Yeah, always finish a video before trying to figure out how to do something. Chances are it will be covered. My advice is to NOT store the order total in the order table. You can calculate it on the fly, like I do, from the order details. Why store it? The only exception would be if you're running MASSIVE reports that have queries with THOUSANDS of orders on them. Storing the order total would make that run faster. But for most databases, it's not necessary. Don't store what you can calculate. However, if you DID want to store it, you'd need an AfterUpdate event each time a line item was modified, added, or deleted. It's a pain.