AdodcLine.RecordSource = "SELECT * FROM " & cboSite.Text
AdodcLine.Recordset.Requery

cboLine.Clear
For intLine = 0 To AdodcLine.Recordset.RecordCount - 1
'Add from Table Shift in Database
cboLine.AddItem AdodcLine.Recordset.Fields(0)
AdodcLine.Recordset.MoveNext
Next intLine
cboLine.Text = adoData.Recordset.Fields(0)

however when i requery it doesnt pick the info from the new record source, can see is in the .recordsource

goes through requery but Recordset.RecordCount is just the old info, like its not updated?

please help