Getting Selected Values and Selecting them in other field

[eiconsulting]

Sorry I am not good enough to solve this, my goal is to switch from one date field to another while keeping the selections (i.e. byInvoiceDate vs. byOrderDate) I need to read the selected values on one field and apply them on another, then I clear the first one. Obviously the selection can include more than one QTR or Month, anyway the GetSelectedValues returns an array and you cannot just use A.text to pass it ...

Problem is that if I do it with the FOR only the last value of the array gets re-selected overwriting any previous selections that were applied in turn, I cannot find a way to use the Select directly with the object A as an array.

Any advice? 😉

Flavio

 set A = doc.fields("Quarter").GetSelectedValues
 for i = 0 to A.Count - 1
 doc.fields("Quarter2").Select A.Item(i).text
 next
 doc.Fields("Quarter").Clear

[#2]

Use ToggleSelect

[eiconsulting]

I cannot see how, for what API Guide tells ToggleSelect is a function to select field values matching a given string.

I don't have a string, do I have to transform my object A into a string and then apply that to the xx.Select?

I have specific values inside a variable (object A) and want to write them into a new field. I need to use xx.Select with an array instead of a single value. Or in a way that is cumulative. I even tried xx.Select.Add ...

Flavio

[prieper · Accepted solution]

Dear Flavio,
think that a macro similar to the attached file should solve your problem

Have Fun!
Peter

[eiconsulting]

Actually your solution was SO INTENSIVE that I used only your last line. SUPER!

Instead of using xx.Select ... xx.SelectValues allows me to set an array in one shot. I'll try more exensively to see if i have to use the whole code but this appear really to be it.

[code/]

set A = doc.fields("Month2").GetSelectedValues --- gets the selections from Month2
doc.fields("Month").SelectValues A --- sets the selections on Month
doc.Fields("Month2").Clear --- clears the selections on Month2 to make it ready for next toggle

Many thanks

Flavio