Results 1 to 2 of 2
  1. #1
    ZJGMoparman is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2012
    Posts
    24

    Combo Box add new entry

    I have created a combo box that list the suppliers of a product from another table. Is there anyway I can have the very bottom option of the combo box to have an option to open a separate form to add a new entry to that table if the value needed is not in the combo box? For example, I want to purchase a product from Vendor D, but only have entries for Vendor A, B and C in the Vendor table. Can I make the 4th option in the combo box something that says "Add New Vendor" and when clicked, it will open up the Vendor form to add the information for Vendor D?

  2. #2
    alansidman's Avatar
    alansidman is offline Life @ 7100'
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,459
    Look at this for an alternative solution

    http://allenbrowne.com/ser-27.html

    Alan

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

Similar Threads

  1. Entry is too long for Combo box
    By EinSpringfielder in forum Forms
    Replies: 1
    Last Post: 03-08-2012, 09:27 AM
  2. Subform, Combo Box, Data entry
    By hellojosie in forum Access
    Replies: 2
    Last Post: 11-21-2011, 01:29 AM
  3. Replies: 3
    Last Post: 01-28-2011, 11:42 AM
  4. Combo box/list for data entry.
    By geoffishere in forum Forms
    Replies: 1
    Last Post: 03-13-2010, 04:16 AM
  5. restricting combo box entry
    By fairlo in forum Forms
    Replies: 1
    Last Post: 10-04-2007, 04:05 PM

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 - Senior Forums