Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

look up box for access

Discussion in 'Information Technology' started by richard2367, Oct 28, 2005.

Tags:
  1. richard2367

    richard2367
    Expand Collapse
    Guest

    How do i structure a look up box for a table in which an id number would
    relate to a specific name. for example if i am making a table and in that
    table is a supplier id field, how do i make a look up box so that when
    someone inputs a supplier name the supplier id number would show up
    thanks
    --
    rRrRrR

    ----------------
    This post is a suggestion for Microsoft, and Microsoft responds to the
    suggestions with the most votes. To vote for this suggestion, click the "I
    Agree" button in the message pane. If you do not see the button, follow this
    link to open the suggestion in the Microsoft Web-based Newsreader and then
    click "I Agree" in the message pane.

    http://www.microsoft.com/office/com...-9034-81173e42dc51&dg=microsoft.public.access
     
  2. Loading...


  3. Ken Snell [MVP]

    Ken Snell [MVP]
    Expand Collapse
    Guest

    This feature is already in place... look at Combo Box control for forms.

    --

    Ken Snell
    <MS ACCESS MVP>

    "richard2367" <richard2367@discussions.microsoft.com> wrote in message
    news:94496C24-0ABC-47FB-9034-81173E42DC51@microsoft.com...
    > How do i structure a look up box for a table in which an id number would
    > relate to a specific name. for example if i am making a table and in that
    > table is a supplier id field, how do i make a look up box so that when
    > someone inputs a supplier name the supplier id number would show up
    > thanks
    > --
    > rRrRrR
    >
    > ----------------
    > This post is a suggestion for Microsoft, and Microsoft responds to the
    > suggestions with the most votes. To vote for this suggestion, click the "I
    > Agree" button in the message pane. If you do not see the button, follow
    > this
    > link to open the suggestion in the Microsoft Web-based Newsreader and then
    > click "I Agree" in the message pane.
    >
    > http://www.microsoft.com/office/com...-9034-81173e42dc51&dg=microsoft.public.access
     

Share This Page