[RESOLVED] Fill combobox depending on value of other combo

[bodylojohn]

On which line is the error?
I think in the select statement the "Me.cboLand.SelectedItem" is wrong. it should be "CInt(Me.cboLand.SelectedValue)" if Land_ID type is integer.

Thanks for the quick reply.

When I use CInt(Me.cboLand.SelectedValue), the error is on line
Dim adapter As New OleDbDataAdapter("SELECT Staat_ID,Staat FROM tblSTAAT WHERE Land_ID = " & Me.cboLand.SelectedItem, connection)

The error reads: Conversion of type DataRowView to type integer is not valid.