I am getting an error in Access 2000 that says, "Run-Time error '2501'. The Applyfilter action was cancelled." The "Help" button is dimmed when I get it, so there is no elaboration.
Description:
The form that causes the error looks similar to the "Sales Totals" form in the 'Solutions' database that comes with Access, except there is only one subform. It works like this:
- The data comes from two related tables. Their relationship is one-to-many on a permit number.
- I use a query off the one-side table to produce data on the parent form. I use a query off the many-side table to produce data on the child form.
- A combo box is at the top of the parent form and is bound to the permit number.
- The filter property on the parent form says, "Permit = Forms!frmUpdatePermits!Permit"
- AfterUpdate says, "DoCmd.ApplyFilter , "Permit = Forms!frmUpdatePermits!PermitNo""
- I get the error after selecting a value in the combo box. If I then click on the subform I see the message, "The record cannot be deleted or changed because 'tblAgents' includes related records."
All I am trying to do is to go to a record. I do not want to change it. Even if I use the Access Wizard and use another method besides filtering, I receive similar messages.
Any ideas on what causes this problem?
StephenS
Description:
The form that causes the error looks similar to the "Sales Totals" form in the 'Solutions' database that comes with Access, except there is only one subform. It works like this:
- The data comes from two related tables. Their relationship is one-to-many on a permit number.
- I use a query off the one-side table to produce data on the parent form. I use a query off the many-side table to produce data on the child form.
- A combo box is at the top of the parent form and is bound to the permit number.
- The filter property on the parent form says, "Permit = Forms!frmUpdatePermits!Permit"
- AfterUpdate says, "DoCmd.ApplyFilter , "Permit = Forms!frmUpdatePermits!PermitNo""
- I get the error after selecting a value in the combo box. If I then click on the subform I see the message, "The record cannot be deleted or changed because 'tblAgents' includes related records."
All I am trying to do is to go to a record. I do not want to change it. Even if I use the Access Wizard and use another method besides filtering, I receive similar messages.
Any ideas on what causes this problem?
StephenS
