Need to update a field based on selected ControlSource

[chadz777]

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.

How can I go about doing this?

Thanks in advance

 

[Uncle Gizmo]

On second thoughts, I deleted this post.

 

[odin1701]

Easiest way to do that is to make sure that the ID is a primary key - which it probably should be anyway. If you do a combo box wizard you can select both the ID and the Customer Name, and have it hide the primary key - after that you can look at the properties to learn how to setup one that way. The Value of the combo box will be the ID - so you can just copy that into another field, or use that value to open another form with the order info and copy the value into a field on that form.