Results 1 to 2 of 2
  1. #1
    OZINUK79HOME is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    1

    Smile Populate multiple fields with data relating to specific dropdown selection

    I am trying to create a DB which will allow our warehouse staff to select from a predefined list of items ie. desks each of which has assigned values including weight, £ value, etc. When they select an item i need the relevent fields on the inventory to auto populate with the relevant data ie. they select 1200mm straight desk from the list and the £ Value and Weight fields are automatically updated.

  2. #2
    jzwp11 is offline VIP
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    Welcome to the forum!

    For the controls you which to populate, you can use an expression in the control source property to extract the relavent information from the combo box control. The expression would look something like this:

    =ComboBoxControlName.column(x)

    where x= the column number of the field of the combo box row source that holds the value you want to display.

    For example, if you look at the row source property of your combo box it would look something like this:

    SELECT fieldA, fieldB, fieldC etc. FROM...

    FieldA would be column(0), FieldB would be column(1) etc. (Access starts counting at zero)

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

Similar Threads

  1. Replies: 9
    Last Post: 07-20-2015, 10:55 AM
  2. Populate a field based on combobox selection
    By rscott7706 in forum Access
    Replies: 5
    Last Post: 06-02-2011, 03:18 PM
  3. Replies: 1
    Last Post: 09-02-2010, 03:59 PM
  4. Replies: 2
    Last Post: 08-03-2010, 10:16 AM
  5. Populate one field based upon another fields data
    By BigBrownBear in forum Queries
    Replies: 1
    Last Post: 03-23-2010, 04:27 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