Hi Guys,
I have been going throung old threads for days, trying to find answer for similar issue, but no luck.
I am not capable of writing SQL/VB,
but been using Access with built in functions, or do slight modification from the sample NorthWind.
Here is my issue:
I have two tables, tabel 1: Address book, table 2: Activity Records.
I created a form: Activity Record
Subform1: MultiSelect Listbox with Column1: Name, Column2: Handicap from Query: Address book
Subform2: Activity Record from Table Activity Record, Column1: Name, Column2: Handicap, and other records up to 12 columns.
I wish to add the selected items from the Listbox in Subform1 to Subform2, only for Column1 and Colum2,
created a button, and that is the best I can do!
Wish you genius guys can help.
Thanks in advance
I have been going throung old threads for days, trying to find answer for similar issue, but no luck.
I am not capable of writing SQL/VB,
but been using Access with built in functions, or do slight modification from the sample NorthWind.
Here is my issue:
I have two tables, tabel 1: Address book, table 2: Activity Records.
I created a form: Activity Record
Subform1: MultiSelect Listbox with Column1: Name, Column2: Handicap from Query: Address book
Subform2: Activity Record from Table Activity Record, Column1: Name, Column2: Handicap, and other records up to 12 columns.
I wish to add the selected items from the Listbox in Subform1 to Subform2, only for Column1 and Colum2,
created a button, and that is the best I can do!
Wish you genius guys can help.
Thanks in advance