If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Forms/Subforms
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. My email is |
Thread Tools | |
Display Modes | |
|
|