Results 1 to 7 of 7
  1. #1
    BaldEagleOne is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    6

    Add Item to Existing Drop Down menu in the table


    I'm building a table and have an existing drop down menu in one of the columns. Is there a way to add another item to the drop down list?
    Thanks
    I'm running Windows 10
    Access 2016

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,927
    take a look at the similar threads section of this post - you'll find examples there

    there is also this link https://www.accessforums.net/showthread.php?t=79571

    edit: just realised you are talking about in a table. The answer is no, fields in tables do not have events, and you need an event to trigger the update. You can of course do an update manually in the associated table, but drop downs in tables are considered a bad idea - see this link http://access.mvps.org/access/lookupfields.htm

  3. #3
    BaldEagleOne is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    6
    I'm new to building a database i Access and don't have much time to get it done. Is there someone who can get on GoToMeeting (I have an account) with me and help me get this set up properly? I made a form and when adding a new item, it doesn't go to the table.
    Thanks

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,927
    Not me I'm afraid, it's what I do for a living so would have to charge. Happy to point you in the right direction

    With regards your table not updating, check you have the table name as the form recordsource. Alternatively, if you have created your table, highlight it and then select Form on the create ribbon. That will create your form. Move/resize controls as you see fit or use it to see 'how it's done

  5. #5
    BaldEagleOne is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    6
    I'm willing to pay for your time. An hour should do it. Today, if possible.

  6. #6
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,927
    sorry, not possible at short notice, I have an existing project I have a deadline to finish

  7. #7
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    @BaldEagleOne

    You haven't provided any info about your project. Really hard to provide focused responses.
    Provide more info and maybe post your dB.

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

Similar Threads

  1. Adding fields in existing drop down menu?
    By snowboarder234 in forum Access
    Replies: 5
    Last Post: 03-27-2018, 11:43 AM
  2. Replies: 2
    Last Post: 05-07-2014, 10:24 AM
  3. Different Values in Drop Down Menu and Data Table
    By colourxpalette in forum Forms
    Replies: 4
    Last Post: 05-22-2013, 02:40 PM
  4. Drop down menu help
    By whojstall11 in forum Access
    Replies: 6
    Last Post: 03-07-2012, 01:51 PM
  5. Replies: 3
    Last Post: 11-29-2011, 07:01 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