Data Access Page Error

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

Guest

I have a DAP hooked to a SQL database. One of the fields in the database is
DateCleared as a Date/Time field and formatted for short date. When I made
the DAP I inserted the DateCleared field. Now when I enter a date into the
field and then move out of the field I am getting the following error:

The data was added or updated in the database, but the data won't be
displayed because it doesn't satisfy the criteria in the underlying record
source.

Any ideas on how to fix this?

Thanks
 
I experienced the same error message - after I added a new subform. When I
removed the subform - I still experienced the error message. A workaround is
to turn off the DisplayAlerts in the Page Properties:Data area.
 
I did that and the error message went away. However the record is still
stuck until I can somehow refresh the record. Any ideas?
 
Back
Top