Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Return to place in table

Discussion in 'Information Technology' started by Teebo524, Jul 28, 2006.

  1. Teebo524

    Teebo524
    Expand Collapse
    Guest

    In MS Access 2002, when I exit a record and go back to the main table, it
    returns me to the beginning of the table, rather than returning me to my spot
    in the list, which gets annoying since there are over 1000 records in the
    table. Is there a way to set it so that I can return to my original place in
    the table (where I was when I opened the record)?
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Ontario Police Review Arrest Of Sikh Man Whose Turban Wasn't Returned - CTV News Breaking News Jul 16, 2016
    Movies Ashdoc's short movie review---Tanu weds Manu returns Theatre, Movies & Cinema Jun 6, 2015
    Zoroastrianism Parsis pray for return of the scavenger bird Interfaith Dialogues Aug 28, 2013
    Steve Jobs' Return to Apple Business, Lifestyle & Leisure Mar 28, 2013
    Opinion Campaign to reward homeless man who returned diamond engagement ring hits $175,000 - and that total Breaking News Mar 7, 2013

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    You can't do that in a table, but you can in a form.
    You can make the form in Datasheet view so it looks like the table if you
    wish.

    To achieve what you want, the code must save the primary key value when you
    close the form, and then find that record again when the form is next
    loaded. Details in:
    Return to the same record next time form is opened
    at:
    http://allenbrowne.com/ser-18.html

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Teebo524" <Teebo524@discussions.microsoft.com> wrote in message
    news:C40E186C-91B1-430F-9D0E-9E86616CABF7@microsoft.com...
    > In MS Access 2002, when I exit a record and go back to the main table, it
    > returns me to the beginning of the table, rather than returning me to my
    > spot
    > in the list, which gets annoying since there are over 1000 records in the
    > table. Is there a way to set it so that I can return to my original place
    > in
    > the table (where I was when I opened the record)?
     
  4. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "Teebo524" wrote

    > In MS Access 2002, when I exit a record
    > and go back to the main table, it returns me
    > to the beginning of the table, rather than
    > returning me to my spot in the list, which
    > gets annoying since there are over 1000
    > records in the table. Is there a way to set it
    > so that I can return to my original place in
    > the table (where I was when I opened the record)?


    Are you in a continuous forms view Form before you "open the record"? If so,
    save the unique key of the current record and use it to find that record
    again. Better yet, leave the original "selection" form open behind your
    detail Form, and when you go back, the cursor will still be on the same
    record from which you selected.

    In a sample database, the VBA code (in the DoubleClick event) I use to open
    a detail Form from a Form listing the employees (from the example
    Northwind.MDB) is:

    DoCmd.OpenForm "Employees", , , "[EmployeeID] = " & Me.txtEmployeeID

    And, when I return to the (never closed) employee list form, it is still on
    the same record.

    Larry Linson
    Microsoft Access MVP
     

Share This Page