refreshing or requerying ado based recordsets

[DTSFreak]

Hi,

I'm having trouble with refreshing or requery an ado-based recordset.

I have two forms where the recordset is buildup through an ado-connection. The first form is a continueous form and the second form a detailed form which pops open via a cmd button.

If i update some data on the second form i need to refresh the data on the first form. Before i used me.requery or refresh but that doesn't work on ado-based recordsets.

Anyone have solution?

 

[PHV]

Have a look at the Resync or Requery methods of the ADODB.Recordset object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DTSFreak]

Hi PHV,

I did that but i don't know how to use it. I'm getting a message that the recordset is closed if i do rst.requery in the second form

 

[hwkranger]

close both recordsets and reopen and reset the pass through string for the forms. It takes minimal time (assuming you're using a db-server and not a rst bound to s file-server file.)

Randall Vollen
National City Bank Corp.