Data Access Page Error

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
 
G

Guest

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.
 
G

Guest

I did that and the error message went away. However the record is still
stuck until I can somehow refresh the record. Any ideas?
 

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

Data Access Page. Please Help... 3
Data Access Page Mapped to Database (2003) 1
Data Access Page Mapped to Database (2003) 4
Records aren't editable in Data Access Page 1
#Error in date field 2
data access page synchronize, update or what? 2
Data Access Page 1
Creating a pop up calendar in a data access page 2

Top