Results 1 to 4 of 4
  1. #1
    dragon232 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Nov 2016
    Posts
    24

    How to display a specific field of a specific record only when that record is selected in a form?


    I have a "Multiple Items" form based on a query, and I want some of the fields of the query to be displayed only for the selected record in the form footer. How can I do this? Basically the user would open the form, he would scroll through the records in the "Details" section of the form and see the most important information about each, and then if they actually select a record from that list, I want the detailed fields that aren't shown in the "Details" section of the form to appear in the Form footer. How can I go about doing this? I should mention that I'm new to Access, and have just finished reading one book (Step by Step Microsoft Access 2013 - which is actually not very helpful except for the very basics). So if you have any resources that could help me with this, please also suggest! Thanks!

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    One way would be to include all the fields in the form's source, and in the form's current event have code to display the hidden ones:

    Me.FooterTextbox = Me.HiddenFieldName
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    dragon232 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Nov 2016
    Posts
    24
    Quote Originally Posted by pbaldy View Post
    One way would be to include all the fields in the form's source, and in the form's current event have code to display the hidden ones:

    Me.FooterTextbox = Me.HiddenFieldName
    Okay, seems to work! Thank you for the quick help!

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Happy to help and welcome to the site!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 05-18-2016, 03:32 PM
  2. Replies: 4
    Last Post: 08-20-2015, 05:38 AM
  3. Replies: 2
    Last Post: 01-14-2015, 12:00 PM
  4. Replies: 8
    Last Post: 11-13-2012, 03:36 PM
  5. Replies: 1
    Last Post: 04-11-2010, 04:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums