Professional Web Applications Themes

Subform display's all records/data... - Microsoft Access

....from table. I only want it to display the records/data that corresponds to the record displayed on main form. What am I missing or doing wrong? thanks, skp...

  1. #1

    Default Subform display's all records/data...

    ....from table. I only want it to display the
    records/data that corresponds to the record displayed on
    main form.
    What am I missing or doing wrong?

    thanks,
    skp
    skp Guest

  2. #2

    Default Re: Subform display's all records/data...

    The LinkMasterFields/LinkChildFields properties determine which records are
    loaded into the subform to match the record in the main form.

    1. Open your main form in design view.

    2. Right-click the edge of the subform control, and choose properties.

    3. Locate the LinkMasterFields property (on the Data tab of the properties
    box).

    4. Set this to the name of the control on the main form that the subform
    should match.

    5. Set the LinkChildFields property to the name of the field in the subform
    that should match.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
    Reply to the newsgroup. (Email address has spurious "_SpamTrap")

    "skp" <skpngmpsbcglobal.net> wrote in message
    news:082301c345d5$b8039920$a301280aphx.gbl...
    > ...from table. I only want it to display the
    > records/data that corresponds to the record displayed on
    > main form.
    > What am I missing or doing wrong?
    >
    > thanks,
    > skp

    Allen Browne Guest

Similar Threads

  1. Navigating through records in a subform
    By mate in forum Microsoft Access
    Replies: 0
    Last Post: July 25th, 07:44 PM
  2. Updating records when using a subform
    By M.Lubi in forum Microsoft Access
    Replies: 0
    Last Post: July 23rd, 08:44 PM
  3. A2k: data entry subform for records that don't exist
    By lfaherty in forum Microsoft Access
    Replies: 1
    Last Post: July 22nd, 12:32 PM
  4. Replies: 0
    Last Post: July 15th, 08:01 PM
  5. Cannot delete records in Subform.
    By Bry in forum Microsoft Access
    Replies: 1
    Last Post: July 7th, 11:16 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139