ado requery

[member 472187]

I have a form that on a command button opens a second form to add a new record, then on the update hides the add new form.

How/where do I perform a requery to force the recordset to recognize the new record. The only thing I have gotten working short of stopping and restarting the program is a requery button on the first form. I have tried on the close of the add button, form load of the first, lost and got focus of both and it doesn't perform the requery.

 

[zemp]

The recordset should recognize the new record. But are you using an object to read or display the recordset, such as a data control, ADODC or variable? If so then you will need to refresh the object.

zemp

 

[member 472187]

No, I'm opening a new form to add the new record, saving it and closing the form and going back to the original form. I'm using ADO, no data control, ADOCD or a variable.

 

[zemp]

Is the same recordset being used on both forms or are you using two different recordsets?

zemp

 

[member 472187]

The same recordset is used for both forms.

 

[zemp]

If the one recordset does not show the newly addred record (when you are back to the main form) you can try refreshing the recordset in the form Activate event. This works well if the addnew form is modal.


zemp