Hello,
I have created a Data Access Page that has a querey as it's record source. The querey is designed to retrieve all the records from the databse that have a Null value in a field called "Date Closed". The page loads and displays correctly, but when a value is entered into the "Date Closed" field on the DAP, a message is displayed that says "The Data was added or updated in the Database, but the data wont be displayed because it doesn't satisfy the cryteria in the underlying record source."
I know the message is being displayed because the record that was just updated no longer matches the querey because the "Date Closed" field is no longer null. Is there a way that I can trap this message and prevent it from being displayed?
Any help would be appreciated!
Thanks!
I have created a Data Access Page that has a querey as it's record source. The querey is designed to retrieve all the records from the databse that have a Null value in a field called "Date Closed". The page loads and displays correctly, but when a value is entered into the "Date Closed" field on the DAP, a message is displayed that says "The Data was added or updated in the Database, but the data wont be displayed because it doesn't satisfy the cryteria in the underlying record source."
I know the message is being displayed because the record that was just updated no longer matches the querey because the "Date Closed" field is no longer null. Is there a way that I can trap this message and prevent it from being displayed?
Any help would be appreciated!
Thanks!