access 2010 combo box froma another combo box

[DougP]

I am able to fill a second combo box from the choice in the first but when I pick an item from the second box it jumps to the first item in its list. what am I missing here, on the properties or something? I have done this for 2 decades or so I though but now 2010 is throwing me for a loop.
I even deleted the box and made another one.

Private Sub Combo0_AfterUpdate()
    Dim SQLString As String
    SQLString = "Select Manager, VPName from dbo_SOWManagersTEST " & _
            "Where VPName = '" & Me.Combo0 & "';"
    Me.Combo4.RowSource = SQLString
    Me.Combo4.Requery
End Sub

DougP

 

[dhookom]

DougP,
You haven't told us if your Combo4 (nice name BTW) is bound to a field or what column is bound. If the second column is bound then I would expect the first item to be selected.

Consider changing the name to cboManager or cboVPName or similar.

Duane
Hook'D on Access
MS Access MVP

 

[DougP]

dhookom,
Both combo boxes are unbound, the form is unbound as well.
In properties of Combo4:
Bound column = [highlight #FCE94F]2[/highlight]
Rowsource Type = Table\Query

[highlight #FCE94F]I changed the bound column = 0 in the properties, and that fixed it.[/highlight]

DougP