• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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