In Document Event Triggers, OnOpen-->Select on Field selection

[a0693051]

Hello, Everyone,

I have a hard time finding a solution to the following challenge:

I have a list box called "Buyers' and has 100 values, and I have another field called "Favorite Buyer"(from different source) has 5 values.

When I open the page it will display only the "Favorite Buyer" values in "Buyers" list box as default. later if I want to clear the default values then "Buyers" list box will display all the 100 values.

I have set the trigger like:

Sheet Properties==>Triggers==>OnActiveSheet==>Select in Field==> Field is "Buyers" and Search String is "=[Favorite Buyer]"

but its not working. please help.

Regards

Jhanaarthanan

[sunny_talwar]

Would you be able to share a sample to look at this?

[vishsaggi · Accepted solution]

May be try this in your search string?

Select in Field

Buyers

Search String

= '(' &Concat(DISTINCT [Favorite Buyer],'|') & ')'

[jcampbell474]

I haven't had the best luck using On Open > Select in Field triggers.  A workaround that I usually resort to is entering a search string into the listbox (using the search function), then saving the result as a bookmark.  Create an On Open > Apply Bookmark trigger and see it works for you.

Here's one thread (of many) for reference: Bookmark on Open

HTH,

Jason

[a0693051]

Hi Viswarath,

Thanks for your help and now resolve the issue with your inputs.

I just alter your Search String with below, because in [Favorite Buyer] column values has space in-between and first character is single quote.

Search String

='(' & Concat(DISTINCT chr(34) & [Favorite Buyer] & chr(34),'|') & ')'

Thanks a lot.

Regards

Jhanaarthanan