Error 30014 (1 Viewer)

I am working in a ADP / SQL2000 Enviroment. In a subform i get the data from SQL server with a stored procedure. When i change a value of a record in the subform i get always the error 30014 and the changed record is no longer visible. After a refresh (Menu: Tools\refresh) also the changed record is visible.

Any ideas whats the reason for this? and how can i solve this?

Thanks
Pablo

are you sure the error is 30014 and not 3014 as there is no errors > 15999 in BOL?

Hallo

Yes its realy this number.

Err.Number 30014
Err.Description 'The data was added to the database but the data won't be
displayed in the form because it doesn't satisfy the criteria in the
underlying record source.'

It's crazy, that after a refresh this Record will be shown, that means in my opinion that a wrong error is displayed.
But how solve this?

Thanks Pablo