Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2007
    Posts
    81

    Unanswered: Always show the first record

    Hi Dears

    When I click on the record to open detail form, always show the first record detail for teacher or student,

    Open the MainFrm then click on the First Name.
    Look to the Attach and try click on the second record and next .......

    thanks
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2007
    Posts
    277
    Try this one.
    Attached Files Attached Files
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  3. #3
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388

    Angry Teacher Student Database

    SAMI
    On a previous forum (website) I gave you a solution to your problem, including a sample database. I noticed you are using my form layout etc.

    BUT, you are missing a foreign key in the student table to show the relationship between the student and teacher. Again look at my sample database and you will see that link.

    Allan

  4. #4
    Join Date
    Apr 2007
    Posts
    81
    Thank you so much for all ! I greatly appreciate it.

  5. #5
    Join Date
    Mar 2007
    Posts
    277
    Glad we could help.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by RG's sig
    RuralGuy (rg for short) acXP WinXP Pro
    Please reply to this formum so all may learn.
    Hehe
    George
    Home | Blog

Posting Permissions

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