strange problem while saving in access project

[dorji dukpa]

My front-end is access project and the back-end SQL Server 2000. I have a form with the Recordsource set to a certain record (select * from groups where GrpId=100). When I add a new record and try to save it, access displays a message which says: "The data was added to the database but the data wont be displayed in the form because it doesn't satisfy the criteria in the underlying record source." After this message, the After_Update event of the form is not executed and the newly entered record is no where to be seen although it is reflected in the table

This was not a problem in mdb file. I would appreciate very much if some one could help me with this problem.

 

[JohnFol]

The cirteria selects a specific record. You add a new one. You are warned it
will not be displayed. Why is this strange?

My front-end is access project and the back-end SQL Server 2000. I have a

form with the Recordsource set to a certain record (select * from groups
where GrpId=100). When I add a new record and try to save it, access
displays a message which says: "The data was added to the database but the
data wont be displayed in the form because it doesn't satisfy the criteria
in the underlying record source." After this message, the After_Update event
of the form is not executed and the newly entered record is no where to be
seen although it is reflected in the table.

This was not a problem in mdb file. I would appreciate very much if some

one could help me with this problem.