M
Mary Fetsch
In my Access 2000 project, I set my form's record source in Visual Basic to
a SQL statement that selects, from 2 joined tables, records where the state
is Utah. When I add a new record for Utah, I get the following message
after the Form_Before Update event runs:
"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."
Then the Form_After Update event doesn't run. However, the data does
satisfy the criteria. I presume this is a timing problem of some sort where
the data isn't in the table in time to be found as part of the record
source.
Has anyone else had this problem? Is there a way around it? I'll very much
appreciate any help anyone can give me on this.
a SQL statement that selects, from 2 joined tables, records where the state
is Utah. When I add a new record for Utah, I get the following message
after the Form_Before Update event runs:
"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."
Then the Form_After Update event doesn't run. However, the data does
satisfy the criteria. I presume this is a timing problem of some sort where
the data isn't in the table in time to be found as part of the record
source.
Has anyone else had this problem? Is there a way around it? I'll very much
appreciate any help anyone can give me on this.