+ Reply to Thread
Results 1 to 2 of 2

Form - Combo Box with option that auto-adds new input to source table

  1. #1
    Registered User
    Join Date
    01-22-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    11

    Form - Combo Box with option that auto-adds new input to source table

    Hi,

    I have a Form "Deals" to allow user to create a new records to a table called "Deals"

    One input is "Seller" which specifies the name of a company and the list is generated via table "Company"

    Currently, the user given a combo box has the option to choose multiple company names from the list...however, if a user has a company name that is not currently available on the list...I'd like them to have the option to input a new company name into the Form. Then this new company name should automatically add itself to the "Company" table and therefore it will become automatically available in the Form "Seller" list option going forward....simply, I'd like the user to be able to add a new company name to the list and be restricted to the Form, without having to go into back-end and update the "Company" table.

    Thank you.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: Form - Combo Box with option that auto-adds new input to source table

    Look at this link at Allen Browne's web site for code to do this.

    http://allenbrowne.com/ser-27.html
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA 2007 user form combo box dynamic range row source problem
    By jane serky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2013, 03:33 AM
  2. [SOLVED] User Form Combo Box Input/Value Source
    By jane serky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-01-2013, 06:54 AM
  3. Looping a data input form based on form option
    By bologne in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 04-17-2011, 03:06 AM
  4. User form with combo/option box dependencies
    By jcarstens in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2009, 03:06 PM
  5. [SOLVED] Source code for combo box in form
    By shnim1 in forum Excel General
    Replies: 1
    Last Post: 04-13-2006, 11:50 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1