Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2014
    Posts
    22
    Provided Answers: 1

    Answered: Button of Queried form to view record in another form

    I have a form (Issue Details) with 50 records. I have another form showing the results of a query resulting in 10 records. On the Queried form shows the ID, Title, Description of records. Can I do something where when a user either clicks on the ID or Title, It displays the specific record in the Issue Details form?

  2. Best Answer
    Posted by ranman256

    "in the list form, put a 'DETAIL' button at the top of the form, so whatever record it is on, you can jump to that detail rec.

    docmd.openform "frmDetail",,,"[id]=" & txtID

    (the txtID is the box name of your id on the form...most likely ID. I thru in the txtbox notation.)"


  3. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    in the list form, put a 'DETAIL' button at the top of the form, so whatever record it is on, you can jump to that detail rec.

    docmd.openform "frmDetail",,,"[id]=" & txtID

    (the txtID is the box name of your id on the form...most likely ID. I thru in the txtbox notation.)

  4. #3
    Join Date
    Nov 2014
    Posts
    22
    Provided Answers: 1
    Worked Perfect, Thanks!

Posting Permissions

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