Adodc

[Robbo]

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

[Hack]

If you are trying to get a count of the items in your combobox use Combo1.ListCount

[RobDog888]

This will explain some issues with RecordCount
http://www.vbforums.com/showthread.php?t=526882

[brucevde]

The Recordset does not "know" that the ADODC.RecordSource property was changed. It has its own Source property that contains the SQL Statement.

When you change the ADODC.RecordSource call the ADODC.Refresh method which forces the ADODC to update/create its underlying Recordset.

[dee-u]

Instead of using Recordcount you can just use the EOF property to retrieve all the records.

Do While Not AdodcLine.Recordset.EOF
    cboLine.AddItem AdodcLine.Recordset.Fields(0)
    AdodcLine.Recordset.MoveNext
Loop

And it is always adviced not to use a data-bound control since they tend to present problems, you can just use plain ADODB, there is a tutorial on my sig on how to do that.

[Robbo]

The Recordset does not "know" that the ADODC.RecordSource property was changed. It has its own Source property that contains the SQL Statement.

When you change the ADODC.RecordSource call the ADODC.Refresh method which forces the ADODC to update/create its underlying Recordset.

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

am doing this but doesnt seem to work???

what am i missing??

[Hack]

Refresh not Requery