Results 1 to 2 of 2
  1. #1
    thangvo007 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    2

    With a single click, can I select the values from a multiple-column list box/combo box?


    I created a combo box housing values in its three columns, which will be used for 3 different fields on my form.
    I can select those values to my form one at a time.
    But I want to know is there a way I can fill out my three fields with only ONE click?
    Your response is greatly appreciated.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    The simple answer is, yes. The full explanation why is lengthy. However, you do not want to do this. You do not want to "fill out my three fields" because of the Rules of Normalization. (I am imagining you request is how to write data from the three fields to another table)

    The answer:
    Use the Key value from the combo. Store the Key value from the comb in a Foreign Key field of your table. Display the other three, four, seven, or twenty fields using a query to retrieve the data. Including the Key value in your query should provide access to the relative data.

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

Similar Threads

  1. Replies: 75
    Last Post: 06-03-2014, 09:49 AM
  2. Replies: 3
    Last Post: 07-23-2013, 02:53 PM
  3. Replies: 14
    Last Post: 12-15-2012, 02:59 AM
  4. Replies: 6
    Last Post: 08-30-2012, 06:23 PM
  5. Replies: 1
    Last Post: 08-21-2009, 06:52 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