Catch an error

[human_anomaly]

I have a form that allows the user to edit data, but it only displays records of one student that the previously selected. The user is able to edit the student name. When they do this the student will no longer be displayed on the form since it does not meet the criteria of the student that the selected.
However the system keeps sending out an error message that I can't seem to catch. It says "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." I have tried to hide this message by using DoCmd.SetWarnings False before the message occurs but it still comes up. Does anyone know how to get rid of this message?

 

[Ashfaque]

Hi,

Is it possible for you to attach your zip file here to check.

Regards,
Ashfaque

 

[ecniv]

Rethink the editting form perhaps so it won't allow new records and only allows the user to edit the selected record?

 

[human_anomaly]

it doesn't allow new records to be created