Results 1 to 5 of 5
  1. #1
    Akchayan is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Aug 2022
    Posts
    102

    Transfer column from a dropdown list specifically to table when button is clicked

    Hello all,


    I have a form in which I have a dropdown list. This dropdown list has a total of 3 columns. As soon as the button "Next" is clicked, I would like to transfer the content of the 3 columns into a table.
    The column in the table is called column3.
    The name of the dropdown list is "TEST"
    How do I do this?

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Is this for learning/practice only or is there another reason? This is not something you'd normally do. Care to elaborate?

    If you must, and will use code you can create an update sql by referring to the column numbers (0 based, so 0 is the first) and getting those values from the selected list row.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    think you need to clarify your requirement and provide some more detail, and would be very helpful if you describe the reason for wanting to do this as at the moment, it does not make sense

    1, your title says 'Transfer column from a dropdown list' whilst your thread says ' I would like to transfer the content of the 3 columns into a table.' so which is it?
    2. Where does the data displayed in the dropdown come from? a table? a value list?
    3. what does 'transfer the content' mean? Add to another table? update existing rows in the table?
    4. Does anything else need to be added to the table (such as a foreign key)
    5. You want all the rows in the dropdown to be 'transferred'
    6. 'Transfer' implies adding to one place and removing from another (otherwise you would be copying) so are these rows to be removed from the dropdown?

  4. #4
    Akchayan is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Aug 2022
    Posts
    102
    Quote Originally Posted by Micron View Post
    Is this for learning/practice only or is there another reason? This is not something you'd normally do. Care to elaborate?

    If you must, and will use code you can create an update sql by referring to the column numbers (0 based, so 0 is the first) and getting those values from the selected list row.
    You mean like that:
    Str(Nz(Me![Combo20], 0))

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    No, and why would you need nz? You have blanks in some columns in some list rows??
    More like
    Me.Combo20.Column(0) for 1st column. You could look up Column property of a combo box to get more info.
    Still think you should explain as CJ suggested.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 6
    Last Post: 05-16-2020, 03:14 PM
  2. Removing a dropdown list from a table
    By George in forum Access
    Replies: 1
    Last Post: 10-15-2017, 09:57 AM
  3. Dropdown list info not correct in table
    By hendrikbez in forum Forms
    Replies: 1
    Last Post: 03-13-2015, 07:43 AM
  4. Replies: 12
    Last Post: 09-13-2012, 12:07 PM
  5. Replies: 2
    Last Post: 10-11-2011, 07:24 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