record selectors enabled in contiuous form : how to see if all records are deleted: RRS feed

  • Question

  • Is there an easy way to see if the user deletes all the records on a continuous form with the recordselectors ?
    Tuesday, August 2, 2016 8:05 AM


  • There is a record count displayed at the bottom of the form by the navigation buttons, which displays "record 1 of 15", or similar.  This will display "1 of 1" when all records are deleted (the '1' is the new record which you are editing at that point). 

    If you want to determine this programmatically:

    MsgBox Me.Recordset.RecordCount

    Miriam Bizup Access MVP

    • Marked as answer by tekoko10 Tuesday, August 2, 2016 12:07 PM
    Tuesday, August 2, 2016 10:15 AM