RecordsetClone problem

[MikeAngelastro]

Hi,

I have a form with a few subforms. The form also has a quick find combo box that uses the RecordsetClone method and the bookmark properties to get to a specific record in the form's record source. It works well when I open the form and as long as I don't change any of the underlying data. But when I change the data for the form's current record, the quick find feature to navigate to another record doesn't work. The reason is that setting a recordset object to the form's recordset clone doesn't work at that time. I have to close the form and then reopen it for the RecordsetClone method to work. The error is 3420 - recordset object is no longer set.

I tried to requery the form in order to simulate the closing and reopening of the form, but it doesn't help.

Does anyone know of any other way I can simulate closing and reopening the form with code? Or what actions tend to disable the a form's RecordsetClone method?

Thanks,

Mike

 

[MikeAngelastro]

Hi,

I found the answer to this on another forum but I think that the users of this forum would be interested in it.

If you make any changes to data on a form within a transaction, do NOT close the workspace. This causes problems later.

I was closing the workspace. As soon as I removed the code that closed the workspace, quick find worked.

Thanks,

Mike