Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2013

    Unanswered: combo boxes in tables


    Is it possible to add combo boxes to tables? Is this done via Data Type > Lookup Wizard?


  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    a table is a datastore
    combo boxes are a way of showing data and as such are part of the userinterface (and especially forms

    what you can do is define another table that stored the Primary Key and other data for the attribute, and store the foreign key (the same relevant value as the PK in the other table and use a combo or listbox to represent that data in a form
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    A Lookup Field in a Table is a very bad idea! For the reasons why they should never be used, read the article "The Evils of Lookup Fields in Tables" here:

    The Access Web - The Evils of Lookup Fields in Tables

    End Users should only have direct access to Forms or Queries, never to Tables, when entering/editing Data.

    Note that this refers to Lookup Fields in Tables not to Comboboxes in Forms, being used to lookup Records. That is something else all together.

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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