Results 1 to 3 of 3
  1. #1
    PinkLady50 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    171

    Access 10: Need help writing data from listbox to table.


    Hi,
    I am an "Advanced Novice" user. I know a little but not a lot!

    I have a database that I did not design but have been asked to make changes to.

    I have a Multiselect Listbox lstCAR that I need to write the results from to a table when the record is created. The old database was using a bunch of checkboxes and we ran into some issues.

    I can get the Listbox to correctly display the required data - good there! But the data field called Problem is not part of the Nonconformance_Record which is the Record Source for the form.

    So how do I connect the results of the listbox to the Nonconformance_record.?
    lstCAR = Displays Problem field from the Problem Table.
    Problem ID in Problem tbl needs to connect to Problem ID in Problem_Record tbl and to Nonconformance_Record tbl

    I have attached a copy of the Relationships and the Form if that helps?

    Many thanks!!
    Attached Thumbnails Attached Thumbnails Relationships.PNG   Index form.PNG  

  2. #2
    PinkLady50 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    171
    I made a mistake in my last message. My lstCAR pulls both the ProblemID and Problem. I am only displaying the Problem for the user to see.

    So, the ProblemID needs to write to the ProblemID in the Problem_Record tbl which ties to the ProblemID in the Nonconformance_record that it is linked to.

    I provided a screen shot to show how the records are writing up until now but since I have changed the form to this lstbox I am not sure how to write an VBA statement to link all of this together.
    Attached Thumbnails Attached Thumbnails Nonconformance_Record.jpg  

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

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

Similar Threads

  1. Replies: 4
    Last Post: 02-02-2015, 07:47 PM
  2. Replies: 0
    Last Post: 07-31-2012, 10:33 PM
  3. writing data from recordset to table
    By akrylik in forum Access
    Replies: 5
    Last Post: 05-23-2012, 05:48 PM
  4. Writing ASP into a Data Access Page
    By nellb13 in forum Programming
    Replies: 0
    Last Post: 07-19-2010, 12:23 PM
  5. Writing data from textbox to table
    By mll in forum Forms
    Replies: 4
    Last Post: 03-10-2010, 05:10 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