Results 1 to 2 of 2
  1. #1
    state90 is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2014
    Posts
    6

    Field 2 Dependent on Combo Box selection (Field 1)

    On an input form that captures customer information I have a combo box that provides the data selection for field 1. I need field 2 to populate depending on the selection for field 1.



    Details:
    Field 1 is actually Product Code
    Field 2 is actually Product Description

    The combo box is based on a table called "Products" and has two columns as follows:

    Product Code Product Description
    ABC Acronis Backup Cloud
    SPLA Service Provider License Agreement

    Question: What do I need to do to make the Product Description field auto-populate depending on the Product Code selection using the combo box?

    Thank you,

    Kurt

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    How about:

    BaldyWeb - Autofill
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 4
    Last Post: 06-01-2014, 09:09 PM
  2. Populate Field from Combo Box Selection!
    By mfearer94 in forum Access
    Replies: 5
    Last Post: 05-22-2014, 04:49 PM
  3. Replies: 6
    Last Post: 02-01-2013, 10:02 AM
  4. Replies: 4
    Last Post: 02-08-2011, 08:43 AM
  5. Replies: 3
    Last Post: 02-26-2009, 10:17 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