Auto Select Fields in List Box based on a selection

[Anonymous]

I have data in below format in a list box .If I select 'A&B' field it should auto select A as well.If I select field value 'C&D' it should select 'C' as well .

column
A
A&B
C&D
D

Please help me with logic

[girirajsinh]

Hi Krishna

Try this,

and surely you can make it more dynamic by using strings and conditional functions. This is just to give you some direction.

expression for search string should be

[johnw]

Not exactly what you asked for, but I'd probably handle this in the data model with a new table and field:

column selector,column
A,A
A&B,A
A&B,A&B
C&D,C&D
C&D,D
D,D

Just make a list box for column selector with a legend of column, and it will "select" the desired values of column.