Results 1 to 3 of 3
  1. #1
    shuddle is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    36

    Multiple in text box to populate a table

    I've reviewed several threads and I think this can be done. I'm inexperience in SQL and I know there is coding involved in doing this task so I'm hoping someone can dummy it down for me.



    I've attached a sample of my database. This is what I want to do:

    In the Fm_Contact_Details there is a button that open up another form with two lists, Programs & Entities. The user selects multiple data in each list and the relevant data populates the ContactPrograms and ContactEnities fields as a string (i.e. SO, FSA, TCM) & (GSA, ISC). These fields are connected to the Tbl_Contacts.

    I'm probably making this more complicated than it should be but I'd appreciate any help.
    Attached Files Attached Files

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    2,686
    See if this helps


    Click image for larger version. 

Name:	LISTBOXES.png 
Views:	13 
Size:	32.0 KB 
ID:	45041
    Attached Files Attached Files

  3. #3
    shuddle is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    36
    That's exactly what I wanted. Thanks so much for writing the code.

    Have a blessed day!

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

Similar Threads

  1. Replies: 9
    Last Post: 01-03-2020, 10:50 AM
  2. Replies: 5
    Last Post: 06-27-2018, 05:33 PM
  3. Replies: 5
    Last Post: 06-19-2015, 11:36 AM
  4. Replies: 1
    Last Post: 12-16-2014, 09:16 AM
  5. Replies: 11
    Last Post: 01-25-2013, 12:03 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