Professional Web Applications Themes

Display whole record - Microsoft Access

The best way to do this is to use an unbound combo (one with nothing in its Control Source property) for navigation. Details: [url]http://users.bigpond.net.au/abrowne1/ser-03.html[/url] -- 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") "sniklacs" <scalkinscox.net> wrote in message news:89d701c34565$92177490$a401280aphx.gbl... > I am new to Access and databases in general. I would like > to pull up an entire record when I select a value from a > combo/list box in my form. The field I am selecting from > is the primary key....

  1. #1

    Default Re: Display whole record

    The best way to do this is to use an unbound combo (one with nothing in its
    Control Source property) for navigation.

    Details:
    [url]http://users.bigpond.net.au/abrowne1/ser-03.html[/url]

    --
    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")

    "sniklacs" <scalkinscox.net> wrote in message
    news:89d701c34565$92177490$a401280aphx.gbl...
    > I am new to Access and databases in general. I would like
    > to pull up an entire record when I select a value from a
    > combo/list box in my form. The field I am selecting from
    > is the primary key.

    Allen Browne Guest

  2. #2

    Default Re: Display whole record

    Thanx. I just needed to keep reading other posts. I
    guess this question comes up quite a bit.

    >-----Original Message-----
    >The best way to do this is to use an unbound combo (one
    with nothing in its
    >Control Source property) for navigation.
    >
    >Details:
    > [url]http://users.bigpond.net.au/abrowne1/ser-03.html[/url]
    >
    >--
    >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")
    >
    >"sniklacs" <scalkinscox.net> wrote in message
    >news:89d701c34565$92177490$a401280aphx.gbl...
    >> I am new to Access and databases in general. I would
    like
    >> to pull up an entire record when I select a value from a
    >> combo/list box in my form. The field I am selecting
    from
    >> is the primary key.
    >
    >
    >.
    >
    sniklacs Guest

Similar Threads

  1. How can I display daily record?
    By faiz2000 in forum Dreamweaver AppDev
    Replies: 1
    Last Post: April 3rd, 06:14 AM
  2. How can I make display weekly record?
    By faiz2000 in forum Dreamweaver AppDev
    Replies: 1
    Last Post: February 28th, 10:03 PM
  3. How to display first record in bold
    By dr. zoidberg in forum PHP Development
    Replies: 3
    Last Post: November 15th, 01:13 PM
  4. last record doesn't display
    By middletree in forum ASP
    Replies: 6
    Last Post: October 27th, 10:33 PM
  5. Replies: 1
    Last Post: October 3rd, 04:20 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