I am doing my first DLookup. I have a form who's record source is a table called Caller Info. The form is also called Caller Info and has a combo box field called Customer. When the user selects a customer from the drop down list, the form needs to reference a short table (called Customer) that establishes the relationship between the Customer and the customer's corresponding Number_system. Then it needs to put the Number_system in a text box on the form. In other words, I need it to automatically fill that field (text box) based on the Customer that the user chooses. This is the line of code that I currently have in the text box properties Control Source.
The test box is currently giving me a #Name? error.