Results 1 to 9 of 9
  1. #1
    jarena is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2021
    Posts
    20

    Should I create a combo box at the table level or form level?


    I am in the process of creating an Access Work Order Application which will include several fields that I plan on using combo boxes to populate, some via value lists and others via tables. Is it better to create these combo boxes at the table level or the form level and what are the advantages of adding combo boxes at the table level verses the form level?

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Only use them in forms.

    See: http://access.mvps.org/access/lookupfields.htm
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    jarena is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2021
    Posts
    20
    Good reference, thanks Bob.

  4. #4
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272
    As much as possible, use the forms. But if you will like to create the option for users to add an item to the combo, then you can link the combo of the form to a specific table.

  5. #5
    Synergy.ron@gmail.com is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Location
    washington
    Posts
    126
    Thanks Bob, I was also 'wondering about this issue'

  6. #6
    jarena is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2021
    Posts
    20
    Thanks for the recommendation Emmanuel. I believe storing all dynamic data in tables that will be loaded into combo boxes seems to be a good idea.

  7. #7
    Synergy.ron@gmail.com is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Location
    washington
    Posts
    126
    Is there a 'special' admonition when the underlying query is a self-join on a form...not datasheet? and the fk?

  8. #8
    Synergy.ron@gmail.com is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Location
    washington
    Posts
    126
    Myquestion is:
    I have a membership table. Most Members have beenSponsered by other members so I am usin a self join The form is based on the tblMembers table.The problem isI want to use a combobox for idMember and MemberID. I can't get it to work.....Ideas appreciated.
    Attachment 47192

  9. #9
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Is Sponsors an alias name for second instance of Members table?

    What does "can't get to work" mean - error message, wrong result, nothing happens?

    This query is for combobox to select sponsor? Why are you using self-join query?

    If you want to provide db for analysis, follow instructions at bottom of my post.

    You should have started your own thread instead of hijacking an old one. New threads get more attention. Include link to a thread if you think it has relevant info. Your issue is not the same.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 9
    Last Post: 08-18-2020, 02:32 AM
  2. Combo Box at Table or Form Level - which is best?
    By rodeogal in forum Database Design
    Replies: 4
    Last Post: 04-18-2018, 06:33 AM
  3. Replies: 2
    Last Post: 02-12-2015, 06:27 PM
  4. Linking Tables at the Table Level Vs. the Query Level
    By Tammy in forum Database Design
    Replies: 3
    Last Post: 12-03-2014, 01:34 PM
  5. Create new form instance at the module level
    By DevSteve in forum Modules
    Replies: 1
    Last Post: 09-11-2012, 11:47 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