MIcrosoft Access Navigation History Tracking RRS feed

  • Question

  • I'm looking for code examples/articles to trace navigation through records that have parent/child relationships. Basically - a back button, like web pages have. I haven't tested anything yet - but the plan is to make a temp table, that I can open as a recordset, with a standard module, then add/remove record references to the temp recordset, as I traverse my data tables.

    i.e. A master parts list table of all parts, with a sub-assemly table defining children of other parts, and a temp table to track navigation as I traverse parts. Selecting a new record on the main form, or sending a child from a subform to the main form, adds to the temp recordset - the back button traverses backwards through the recordset, while deleting previous temp recordset entries. All tracking will be of entries into, or sent to, a single Unbound ComboBox.

    Links to articles, and/or general discussion of concepts are fine...

    Friday, September 28, 2018 12:15 AM

All replies

  • There is nothing built into Access to help you with this. You have to implement this all yourself.

    while deleting previous temp recordset entries
    That is not like the browsers I use: I can go back a few pages, then forward again to the same pages.

    Sounds like a lot of work. You better be sure your users REALLY REALLY need this.

    -Tom. Microsoft Access MVP

    Friday, September 28, 2018 2:11 PM