Solved Adding multi selected items from listbox in subform1 to subform2 (1 Viewer)

Wildboy99

New member
Local time
Today, 21:40
Joined
Mar 5, 2020
Messages
10
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
 

Ranman256

Well-known member
Local time
Today, 09:40
Joined
Apr 9, 2015
Messages
4,339
Dont use muli select list box. It requires a lot of programming.
instead, use a single list box, then the user will dbl-click the item. (1 macro)
this runs an append query to add the item to the target table.
 

Attachments

  • pick state-lbl.png
    pick state-lbl.png
    34.2 KB · Views: 88

Wildboy99

New member
Local time
Today, 21:40
Joined
Mar 5, 2020
Messages
10
Dont use muli select list box. It requires a lot of programming.
instead, use a single list box, then the user will dbl-click the item. (1 macro)
this runs an append query to add the item to the target table.

Thanks for reply,
Is there a sample of setting up the macro?

Rather run apend query, can the items be added directly to subform2?
(As there are colums in subform2 linked to the main form, which has to have values)
 

Wildboy99

New member
Local time
Today, 21:40
Joined
Mar 5, 2020
Messages
10
Sorted!
found an old thread that did exactly what I need


Thanks
 

Users who are viewing this thread

Top Bottom