Bind a linq query to a combo box's text only, without altering the items collection

See more:

VB

LINQ

combobox

I've run into an interesting problem binding a combo box with a Linq query. I'm sure I'm just not hitting on the right combination but it's got me frustrated and chasing my tail.

For example, I have a linq query that merely loads an entire table into the query (no where clause) for my flock of chickens.

Private Sub frmBirds_Shown(sender As Object, e As EventArgs) Handles Me.Shown
       Dim BirdQuery = (From b In Main.db.Birds Select b)
       BindingSource1.DataSource = BirdQuery
   End Sub

I have a combo box showing that birds gender, and set the item collection to Male, Female, and Undetermined (it's pretty tough knowing a baby chick's gender) and the text is bound to the query's field. As long as I don't try to change anything, the bindings work fine. However, if I change something from say Undetermined to Female, the whole form changes to the data for the first record with Female. (the datasource pointer changes to that record) Also, it populates the item collection with all of the records. I might have hundreds of Males, Females and Undetermined. It's behaving like a pretty cool search/browse form with every field being a new search.

The designer generated code for this representative combobox is:

'ComboBox1
'
Me.ComboBox1.DataBindings.Add(New System.Windows.Forms.Binding("SelectedValue", Me.BindingSource1, "Gender", True))
Me.ComboBox1.DataSource = Me.BindingSource1
Me.ComboBox1.DisplayMember = "Gender"
Me.ComboBox1.FormattingEnabled = True
Me.ComboBox1.Location = New System.Drawing.Point(165, 150)
Me.ComboBox1.Name = "ComboBox1"
Me.ComboBox1.Size = New System.Drawing.Size(121, 21)
Me.ComboBox1.TabIndex = 3

It seems to be only the comboboxes that cause a record change. The text boxes, and Trackbars seem to behave normally.

My question is what should I bind to only affect the text value, and not the list values for that combo box. Gender isn't the only combo box that has to be populated with various options. For most of these combo boxes, static list items are provided, and others will be provided through another query (not yet written) that will list other bird id's for parentage, flock assignments etc, however these list items aren't part of the original BirdQuery and aren't going to be modified.

As my original (unimproved) question hinted at, this is very simple code. The logic on the form hasn't been started yet because the form itself isn't behaving itself yet. I'm just beginning to learn Linq. In the past I would have manually coded the form without bindings and using objects to a SqlDataReader. I'm trying to teach myself more efficient ways, and writing code for my own personal use is one of the ways that I do that, as well as enjoy my hobby. Apologies for the vague original question.

What I have tried:

I've tried changing the bindings to just about every combination I can imagine, Display Member, Value Member, Selected Value Member. Nothing seems to affect the outcome at all.