I have an Access mdb format split database. There are main form and pop-up subform. When I click on ID in main form pop-up subform appearing. This subform has 2 buttons to exit form without saving (Cancel, Exit).
The problem is:
When I filter records in main form by a certain ID, consequently, I have only one record shown. I click on ID and a subform pops-up. Then I click on Cancel (or on Exit), subform closing fine and brings me to the main form. Which is Correct!
However, when I filter by user name created this record or by date, then open the subform and click on Cancel (or on Exit) a warrning windows appearing "the action will reset the current code in break mode". If I click Yes, nothing is happening, If I click No, the subform closing and brings me to the main form as well.
When I filter by other fields (except CreatedBy, CreatedOn, Year, and one text field), everything works correct. What can a reason for inappropriate way to work?