I added in the table that the first combo is drawing from, but no change in the results. I tried as:
Code:
rivate Sub ctlEntID_AfterUpdate()
'Update row source of policy number combobox based on account selection.
Me.ctlPolNum.RowSource = "SELECT PolNum FROM" & _
" tblPolAct.EntID, tblEntity.EntID WHERE EntID = " & Me.ctlEntID & _
" ORDER BY PolNum"
Me.ctlPolNum = Me.ctlPolNum.ItemData(0)
End Sub
And
Code:
rivate Sub ctlEntID_AfterUpdate()
'Update row source of policy number combobox based on account selection.
Me.ctlPolNum.RowSource = "SELECT PolNum FROM" & _
" tblPolAct, tblEntity WHERE EntID = " & Me.ctlEntID & _
" ORDER BY PolNum"
Me.ctlPolNum = Me.ctlPolNum.ItemData(0)
End Sub