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

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
 
S

Sylvain Lafontaine

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a new record to the recordset of a form using ADO (adp file) 8
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Insert Error 30014 4
How can I turn off or bypass the following message? 0
Workaround: ...because it doesn't satisfy the criteria in the underlying record source 2
Record Source Problem 1
ADP - Form Edit 5
Access 2002 ADP & SQL 2005 Views 8

Top