Results 1 to 6 of 6
  1. #1
    Bossforum930 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Aug 2018
    Location
    Los Angeles
    Posts
    25

    Adding list box in access 2016

    Click image for larger version. 

Name:	RIBBON 2016.png 
Views:	25 
Size:	9.3 KB 
ID:	51021Click image for larger version. 

Name:	DROP DOWN BOX ROLES.png 
Views:	25 
Size:	6.7 KB 
ID:	51022

    I'm going mad - again!

    I created a list box in one file and it was so long ago I can't remember how I did it.



    Attached are two screen shots. Where is the DESIGN tab?

    Also a screen shot of the list box I want duplicate in the other file.

    Searched everywhere.

    I would prefer not to share the actual file on this post so If someone can contact me privately via email I will share the file.

    Thanks.

    Norm

  2. #2
    davegri's Avatar
    davegri is online now Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,413
    Listboxes have to be on forms. Create a form and click 'form design' on the ribbon.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    That looks like a lookup field in a table. Most responders here won't use them.
    Table Lookup Fields
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    That is also a combo, NOT a listbox?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    Looks like a table field drop down list to me, so I'd call it that and not a combo since it's not a control whose properties or methods you can work with. As usual, we wait for clarification of some kind...
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    Bossforum930 is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2018
    Location
    Los Angeles
    Posts
    25
    HI. Before I could see all replies, I figured it out. I added a new column with a LOOKUP and no limits to the list so I am good to go.

    Thanks for all your support.

    NORM

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

Similar Threads

  1. Error adding field in Access 2016 using VBA
    By pnpez in forum Programming
    Replies: 26
    Last Post: 05-26-2021, 03:45 AM
  2. Replies: 1
    Last Post: 09-29-2020, 01:32 PM
  3. Replies: 3
    Last Post: 08-27-2019, 12:06 AM
  4. Exporting MS Access 2016 tables as Sharepoint Online List
    By Rykimaruh in forum Import/Export Data
    Replies: 0
    Last Post: 09-16-2017, 11:57 PM
  5. Access 2016 Box combination, auto-list
    By SoulGame in forum Forms
    Replies: 2
    Last Post: 03-08-2017, 01:45 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