When i open the application , based on the user login information. Im comparing the login id and user id in the table. If it match it should show the corresponding user group. the code i used to compre is as below,
=if(Upper(Trim(Right(osuser(),len(osuser())-(FindOneof(osuser(),'\')))))=Trim(Upper([Login Name])),[Office Counsel])
I gave this expression in a list box, when i open the applicaion the list box shows the correct group name of the user. But it should be selected in default rather than we click it and the list box is not showing the grayed out groups. It needs to show the grayed out groups also , so that the user can later toggle between the groups.