data doesn't satisfy the criteria in the underlying record source ERROR Message

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

conleyli@mindspring.com - 08 Dec 2005 18:01 GMT

I keep getting the Error Message: "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 am using a SQL Server
backend and Access 2003 forms. This only happens when I am finished
entering a record.

Any suggestions?

Thanks!
-Lisa

Reply to this Message

Sylvain Lafontaine - 08 Dec 2005 18:48 GMT

MDB file or ADP?

In the case of ADP, here are some possibilities: missing primary key,
missing Unique Table or missing Resync Command. It is also possible that
you are using a filtering View that doesn't permit viewing the newly added
record.

Take a look with the SQL-Server Profiler to see what happens.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

>I keep getting the Error Message: "the data was added to the database
> but the data won't be displayed in the form because it doesn't satisfy
[quoted text clipped - 6 lines]
> Thanks!
> -Lisa

Reply to this Message

giorgio rancati - 08 Dec 2005 18:55 GMT

Hi Lisa,

view this Kb
----
ACC2000: Error When You Add Record to a Form That Is Based on a Stored
Procedure
http://support.microsoft.com/default.aspx?scid=kb;en-us;248095
----

bye

Signature

Giorgio Rancati
[Office Access MVP]

> I keep getting the Error Message: "the data was added to the database
> but the data won't be displayed in the form because it doesn't satisfy
[quoted text clipped - 6 lines]
> Thanks!
> -Lisa

Reply to this Message