Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

Combobox

I have a simple database with two columns, ItemNo & Description. On my form I have 8 comboboxes being used to list the ItemNo(s) from the database by bindingsource. When I select an item number in the first combobox, the other seven cb's fill with the same item number. If I select another item number in a different combobox all the others change with it. I need to have the cb's act independantly.

What do I need to do to correct the problem?
0
Tim313
Asked:
Tim313
  • 2
2 Solutions
 
UnifiedISCommented:
Sounds like all 8 combos are bound to the same source.
0
 
AbhishekoopsCommented:
Ya it seems here all the combo boxes are getting binded to the same single field you are trying to modify.
If you cant really figure out just delete the control then try to configure it with one combo box then move on with the next one and bind it with the required source so that you can avoid the things where you are really making a mistake.
Even if not the do paste your code related to your combo box so that i can have a look at it.
0
 
Tim313Author Commented:
Yeh, I thought binding all 8 boxes to a single field may be the problem. I expanded the database from one "ItemNo" field to 8 fields (all identical with different field names), then bound each combobox to its own field but still got the same results (change one, change all). I had a similar problem setting up two comboboxes on a different form and actually had to create two separate tableadapters to work around the problem. I don't have much code, I'm simply dropping the boxes onto the form from "Data Sources" in designer mode. I'm hoping I don't have to create 8 tableadapters to work around this problem.

I'll try building the form one box at a time to see if I can find the error. I'll repost the results shortly...

Thanks!
0
 
Tim313Author Commented:
Purely by accident, I found the problem. Since I was using a single data source, I needed to set up multiple bindings (one for each cb). Thanks for steering me in the right direction.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now