I have 15 comboboxes on my form. They are all linked to the same column in my database.
eg
my database is called: NightshiftDB
Colums: Callsign
Crewname
CrewContact
CrewPhone
I have set up my comboboxes to show the "callsign"
But when I try to select, for example, call sign 650 in the first combobox and say callsign 710 in the next all the comboboxes change to the same callsign.
I am using VB and sql
Any help with this would be fantastic.
Diane
What I have tried:
I have looked at multiple solutions to this problem but am totally confused as they all seem to disagree with each other and nothing I have tried has worked.
Dim copytable_1 As DataTable
copytable_1 = NightshiftDBDataSet.Tables("callsign").Copy
ComboBox2.DataSource = copytable_1
I tried the above in the formload event (I thought I could do this for each of the comboboxes) but it threw up the following error
System.NullReferenceException: 'Object reference not set to an instance of an object.'
System.Data.DataTableCollection.this[string].get returned Nothing
I'm not sure what this means, or how to fix it.