access vba - Link 2 Listboxes to update table values -

access vba - Link 2 Listboxes to update table values -

i have 3 checkboxs, 2 list boxes , button on form. want check on box select country , select value both boxes update tables data. , delete values sec list box if record exisits on button click.

first list box (lst_vr_table) 5 fields external reference product unit part no serial no received @ location (empty field)

second list box (lst_unmatched_data) 2 fields internal ref received @ location (field value)

table (tbl_vr) multiple fields button (cmd_import)

so take 1 record 1st list box , 1 record 2nd listbox. 2 list boxes have values entered single record table.

what vba code use?

access-vba