Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2012
    Posts
    21

    Unanswered: Next unique record navigation

    I have a table named TableA which consists of following : ( ID is primary key )

    ID SSN Lastname PHONENUMBER
    1 123456789 ASHOK 5097863736
    2 123456789 ASHOK 6572527257
    3 897262562 KUMAR 9897867298
    4 897262562 KUMAR 6572357373

    The subform shows lists data by individual person one person at a time which means

    ID SSN Lastname PHONENUMBER
    1 123456789 ASHOK 5097863736
    2 123456789 ASHOK 6572527257

    To navigate from one record to next in the subform I use the record navigation which defualt comes with ms access.

    Problem: The mainform also has navigation but it goes through all the records sequentially.
    But I want to go next record ( a custom navigation or something like that ) that is..

    FROM

    1 123456789 ASHOK 5097863736

    TO

    3 897262562 KUMAR 9897867298

    Can somebody let me know how to that ?

    Thanks !!

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Do you want to go on third record in MainForm or in Subform ????

  3. #3
    Join Date
    Feb 2012
    Posts
    21
    In the mainform. I should be able to go to the first record of the next person which is actually determined by SSN and Phonenumber.A person can have multiple phonenumbers.

  4. #4
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Look at "DemoNextUniqueRecA2000.mdb" (attachment, zip).
    Open Form1MainF and try.
    Use a combo box on the top of the form.
    Look at VBA, Relationships.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •