Hi there,
I would appreciate it if someone could help me out here, I'm almost desperate
I have a multi select listbox with three columns:
PCN Description Price
111 Ink 50
222 Label 60
333 Case 120
I managed to get all selected values of each column in a new textbox, separated by ";" (assuming 2 selections are made):
txtbox1 = 111;333
txtbox2 = Ink;Case
txtbox3 = 50;120
What I do not get solved is transform the values in the txtbox1, txtbox2, txtbox3 into separate textboxes to further use them, i.e. on an order report to show like this:
Ordered Item Description Unit Price
111 Ink 50
222 Case 120
I tried so many things, split, left, right function etc. but without any success.
Any help and coding would be very much appreciated.
Thanks
I would appreciate it if someone could help me out here, I'm almost desperate
I have a multi select listbox with three columns:
PCN Description Price
111 Ink 50
222 Label 60
333 Case 120
I managed to get all selected values of each column in a new textbox, separated by ";" (assuming 2 selections are made):
txtbox1 = 111;333
txtbox2 = Ink;Case
txtbox3 = 50;120
What I do not get solved is transform the values in the txtbox1, txtbox2, txtbox3 into separate textboxes to further use them, i.e. on an order report to show like this:
Ordered Item Description Unit Price
111 Ink 50
222 Case 120
I tried so many things, split, left, right function etc. but without any success.
Any help and coding would be very much appreciated.
Thanks