strange problem while saving in access project

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
The cirteria selects a specific record. You add a new one. You are warned it
will not be displayed. Why is this strange?


dorji dukpa said:
My front-end is access project and the back-end SQL Server 2000. I have a
Click to expand...
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
Click to expand...
one could help me with this problem.
 
Back
Top