I reference this seminar because it points out the problem I am having.  I am not in need of a work-order solution, but I have studied the first 7 lessons.  Here goes:
Richard, you built a CustomerF, with a listbox showing the locations for the currently displayed customer.  And you can double-click, or use the button to open the LocationF to add/modify the locations for the current customer.  Great.  
The LocationF has a similar listbox to view/add/modify the Units for each location.
So, you open the CustomerF, and from here you can add the various locations and units for each customer.  Everything is great.
Here's my question: What happens when you add a new customer???
Sure, I can open the form and use the record navigator to move to a new customer record.  As I type in the new customer data the little "pencil" appears in the record selector indicating I am entering a new record.  When I tab to the Location listbox, the pencil is still there.  If I choose to clck the Add Location button, the LocationF opens, but I cannot see the new customer in the CustomerCombo on LocationF because Access sees me as still entering the new record.
The only way I've found to "update" the customers is to move off the record and back to it.

This seems like it would be awkward for the user to do.  Is there a way to update/requery/refresh the new customer record, and if so, please tell me how?
Many thanks,
Don

---

Reply from Richard Rost:

Yes, I believe there's a Me.Refresh in there somewhere which saves the new/edited record before moving off it. If I haven't covered it by lesson 7, keep watching. I'm sure that's addressed.