delete record / refresh / requery RRS feed

  • Question

  • i have an old continuous form . the user can click on a button to see details of a record. a new form opens : if he wants to delete he can click on that form, the details are deleted, the program goes back to the first contiuous form , and in the continuous form the users sees #deleted in the fields

    but in another form, similar form, if the user deletes the details, in the continuous form nothing happens. the record is still there, the user must press "refresh all" to see if the record is deleted.

    allthough the programs look very the same (it is even the same detail form) i want to know where the difference comes from .

    Tuesday, May 31, 2016 6:45 AM


  • Try requerying your main form from the Close Event (or other suitable place) of the popup form:


    That will reload the form's records - so that the deleted records do not show.

    Miriam Bizup Access MVP

    • Edited by mbizup MVP Tuesday, May 31, 2016 1:02 PM Typos
    • Marked as answer by tekoko10 Tuesday, May 31, 2016 1:15 PM
    Tuesday, May 31, 2016 1:00 PM