Transfering information

[Young20]

I have three list boxes. Two of them has data from a database in them. I want to chose one piece of data from one index, and choose two pieces of data from the other list, and click a button to send it to another list(database, that would later be exported to excel). Does anyone know how I would go about doing this?

 

[Matt Greatorex]

When the user clicks on the button, you construct a string of all three values. You then insert the constructed value into the table (e.g.

Dim str_Overall as String

str_Overall = [Forms]![[I]Form Name[/I]]![Field1] & " " & _
                  [Forms]![[I]Form Name[/I]]![Field2] & " " & _
                  [Forms]![[I]Form Name[/I]]![Field3]

DoCmd.RunSQL "Insert Into [I]Table Name[/I] Values(" & str_Overall & ");"

Is that the sort of thing you're trying for?