Post reply

Filter Lost Trying to Change Data in a Field

  • June 1, 2005 at 8:07 am

    #67090

    Hello All:

    I've been having a pressing problem with a new access adp I'm implementing. I'll try to explain it as best I can......

    1)Open a form in DS view

    2)ApplyFilter in the Open Event

    3)Filter is applied and works fine.

    4)When the user changes the filtered (combo-box) field the filter is lost and usually the data doesn't change.

    This also happens when a user applies a filter and then tries to change the data in the filtered field.

    I'm really lost on how to figure this out. Could it be a setting? This is one of the most common actions that my users take. So you can imagine how crazy everyone is going.

    If anyone has any ideas, any help will be greatly appreciated. If you need any further information, please let me know.

    Thanks,

    Cleech

  • June 2, 2005 at 2:34 am

    #562433

    Cleech,

    When you change the filtered Combo you are undermining the very filter is operates on.

    Can I suggest:

    Change to ordinary form with subform display. In the main form create your combo box. The subform filtered field should link to the combo box.  In the afterupdate event of the combobox have it requery the subform.

    HTH

    Richard

  • June 2, 2005 at 8:48 am

    #562557

    I just tested your problem in an ADP, and I can't reproduce it.  It works fine for me.  The Filters work fine, even if I edit a record in the filtered field.

    Do you have any refresh or requery or filter code in the AfterUpdate (etc) event of the edited combo box? 

  • June 3, 2005 at 8:22 am

    #562920

    I tried this again on a flat table without any combo-boxes etc. Also without any refresh, requery on any events. Just a datasheet view form with a table as the recordsource.

    I move the cursor to a field and click on the filter by selection button. Once I try to change the data in the filtered field the filter is lost.

    In this case, however, the cursor remains on the edited record and the data IS changed.

    It just seems like too much to write code to handle this. I was thinking about using the screen.activecontrol property in some way, but that would just open it up to more errors.

    Again. Thanks for the help so far and any additional help or suggestions are appreciated.

    Thanks,

    Cleech

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply