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

  • Thread starter Thread starter conleyli
  • Start date Start date
C

conleyli

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
 
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.
 
Back
Top