I have a form with a tab control on it. One tab displays Billing Addresses and another tab displays Shipping Addresses.
I am populating the State (Province)/ Country combo boxes on each tab using the same dataset
Private Sub LoadProvince()
Me.dsProvince.Clear()
Try
Me.dsProvince = objProvince.All
Me.cboBillingProvince.DataSource = Me.dsProvince.Tables("Province")
Me.cboBillingProvince.DisplayMember = "Description"
Me.cboBillingProvince.ValueMember = "ProvID"
Me.cboShippingProvince.DataSource = Me.dsProvince.Tables("Province")
Me.cboShippingProvince.DisplayMember = "Description"
Me.cboShippingProvince.ValueMember = "ProvID"
My problem is that the selection on one tab affects the other as the comboboxes seem to be bound together.
I am populating the State (Province)/ Country combo boxes on each tab using the same dataset
Private Sub LoadProvince()
Me.dsProvince.Clear()
Try
Me.dsProvince = objProvince.All
Me.cboBillingProvince.DataSource = Me.dsProvince.Tables("Province")
Me.cboBillingProvince.DisplayMember = "Description"
Me.cboBillingProvince.ValueMember = "ProvID"
Me.cboShippingProvince.DataSource = Me.dsProvince.Tables("Province")
Me.cboShippingProvince.DisplayMember = "Description"
Me.cboShippingProvince.ValueMember = "ProvID"
My problem is that the selection on one tab affects the other as the comboboxes seem to be bound together.