Hi - I hope someone can help me please. I'm creating a database where customer service agents can enter & track customer complaints. Ok - I've got it set up where they pick their customer name from a combo box. Ok that works fine and it stores picked customer in the "main" table. My problem is that the customer service agent has to be able to see and/or input/edit the name of the person who works for their customer. So I thought a subform would work. Well, I created the subform from the "customers" table. What I want to be able to happen is when the CSA selects their customer at the top of the form - that the subform will autopopulate as well. Its not working quite right. It will only work if I scroll to the next record, then come back to the record I'm working on and the name of the person they need to see/edit shows up in the subform. How can i make that name pop up automatically when they select a name from the customer list? Does that make sense? I hope I wrote there where someone can understand. Any help appreciated.