I want my user to access to only certain listbox Values, only admin should have all access. I have attached an excel and qvw file. In the excel sheet, I have a listbox with called "AccountL01" with XXXXX , YYYYY, ZZZZZ values. And the AccountL01 Sheet in excel has the REDUCTION column gives the reduction id.
So in sheet1 of excel says
Sheet1:
USERID
PASSWORD
ACCESS
GROUP
ACCOUNTL01
Admin
123
ADMIN
*
*
B
123
USER
GROUP1
100
C
123
USER
GROUP2
101
D
123
USER
GROUP3
102
E
123
USER
GROUP4
101
AccountL01:
ACCOUNTL01
REDUCTION
XXXXX
100
YYYYYY
101
ZZZZZZ
102
My requirement is, when User B logs to open, the List box should only show XXXX rest should be disabled or hidden, Same way, when USER C and E log in, the List box should show YYYY and for D it should only see ZZZZZ. The Reduction id identifies the user.
