Refresh an ADODB Recordset

[BorisMartian]

Hi

I've got a form which connects to a networked database. On this form i have a button "Refresh" which when pressed should refresh the recordset.

When i used Data Bound Controls there wasn't a problem when i used the datPrimaryRS.Recordset.Refresh command.

But now I don't have any Data Bound Controls. I just use normal textboxes. The trouble is that i can't seem to work out how to refresh the recordset.

The code i have at the moment is the following:-

Dim cat As New ADOX.Catalog
Dim cnnDatabase As New ADODB.Connection
Dim rs As New ADODB.Recordset

cnnDatabase.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strClients & strSecurity

cat.ActiveConnection = cnnDatabase
cnnDatabase.CursorLocation = adUseServer
rs.Open "SELECT * FROM Clients ORDER BY CompanyName", cnnDatabase, adOpenKeyset, adLockOptimistic


Now can anyone help me get the recordset refreshed?

Thanks in advance.

[mendhak]

You might wanna use


rs.requery