Zacharyjuniorman
New member
- Local time
- Today, 22:28
- Joined
- May 15, 2001
- Messages
- 7
Here is my situation. I have a table that holds the customer information. This table includes customer id, customer name, customer city, customer state, customer zip, and customer phone.
I created a new form that will be used to track customer complaints. Because we deal with the same customers over and over I wanted to and these fields to a form with other fields from other tables. I want the user to select from a drop down box that is driven from the customer name and create an event that will fill the remaining customer data in. The information must be stored in that form.
Here is the vb code I wrote and it does not seem to work. I am very new to vb so please forgive me.Private Sub cboCustomerName_AfterUpdate()
'Auto Insert customer data based on a value selected in the CustomerName combo box.
Me!CustomerName = Me(CustomerName).Column(1)
Me!CustomerAddress = Me!CustomerAddess
Me!CustomerCity = Me!CustomerCity
Me!CustomerState = Me!CustomerState
Me!CustomerZip = Me!CustomerZip
Me!CustomerPhone = Me!CustomerPhone
End Sub
I created a new form that will be used to track customer complaints. Because we deal with the same customers over and over I wanted to and these fields to a form with other fields from other tables. I want the user to select from a drop down box that is driven from the customer name and create an event that will fill the remaining customer data in. The information must be stored in that form.
Here is the vb code I wrote and it does not seem to work. I am very new to vb so please forgive me.Private Sub cboCustomerName_AfterUpdate()
'Auto Insert customer data based on a value selected in the CustomerName combo box.
Me!CustomerName = Me(CustomerName).Column(1)
Me!CustomerAddress = Me!CustomerAddess
Me!CustomerCity = Me!CustomerCity
Me!CustomerState = Me!CustomerState
Me!CustomerZip = Me!CustomerZip
Me!CustomerPhone = Me!CustomerPhone
End Sub