Unanswered: Need to update a field based on selected ControlSource
I have a combobox that selects the customer and shows related information on that customer such as phone number, cc#, etc..
now the trick is i need to allow the selected member to be added to the order information.
For instance, the user selects the customer "Bob" and bobs information is displayed to check for accuracy. After the info is approved the user will continue to process his order. In order to do this I need the customer ID to be the same as the selected customer in the combobox.
Then the user will proceed to fill out the order information, location, date, time, etc.
I would use the After Update event for the combobox. When the user selects a customerid, then have code in the event to set the customerID field to the one selected by the user.
Sorry my answer is so vague, but if you want a more detailed answer then I suggest giving more details (especially names) about your form. For example, what is the name of the combo box? The name of the field that is bound to the CustomerID field? Are the two fields on the same form? If not, what are the names of the forms?