Results 1 to 4 of 4
  1. #1
    dalanengle is offline Novice
    Windows XP Access 2000
    Join Date
    Sep 2009
    Posts
    3

    How do I choose a record from a list and it populates a form?

    I have a form that displays client information (named "Clients Information").


    I have a drop down list on the firm that displays all the clients in my database. My question is how do I click on a client from the drop down list and have it fill in all the fields on the "Client Information" form. I want the list to be included on the Client Information form as well as all the fields.

    Please help a newb out!!!

    Thanks.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,899
    Add another ComboBox to your form with the cbo wizard and select option 3.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    dalanengle is offline Novice
    Windows XP Access 2000
    Join Date
    Sep 2009
    Posts
    3

    Thanks

    That was ridiculously simple. Thanks a lot. I have been trying to figure this out for about three days! I have thousands of questions about this program. I'm new to this, just trying to make a program for my wife's business.

    Thanks again! I'll probably have more posts I'm sure!

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,899
    Glad I could help. Go ahead and use the Solved thread tool.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. list attachments in form
    By hawaiikim in forum Forms
    Replies: 0
    Last Post: 08-24-2009, 11:08 AM
  2. Replies: 3
    Last Post: 06-27-2009, 03:53 PM
  3. Replies: 14
    Last Post: 06-24-2009, 07:36 PM
  4. Open Form with a drop down list box
    By Rinehart in forum Forms
    Replies: 0
    Last Post: 08-10-2008, 08:53 PM
  5. How do I choose multiple records for a report
    By admaldo in forum Reports
    Replies: 2
    Last Post: 03-03-2006, 06:02 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums