I have a continuous form that is bound to a stored procedure.

After editing a record on the form and either moving to a different record 
or explicitly saving the record i get the following error...

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.'

The data i edit does not change a primary key, foreign key or data 
involved in a join within the stored procedure, nor does it change the 
data in such a way that it doesnt meet the criteria of the stored 
procedure.  I have tried assigning the stored procedure to the form via 

    rst.open "EXEC mystoredprocedure"
    form.recordset = rst

and also

   form.recordsource = "EXEC mystoredprocedure"

and also

  setting the record source in the properties tab along with the input 
parameters and unique table property

The data is saved successfully and does not violate any rules or 
constraints.

What on earth am i doing wrong?