Sir ,
How are you its long I did not post , I faced an issue with my database I need your help.
i am working on a database with multi user access with different security level
i created a search form "000-SEARCH PROJECT QUERY" based on query.
1- Combobox "combo41" (show proponent values from the qry
2- Listbox "List50" (Populate the filtered data based on combobox
3- Textbox "text22" (auto populate the login user security level i.e "1",2
Aim
when a user with login by his security level i.e "1"
when he execute the search form the combox will show him just those proponents he is responsible which comes under his security lvl
so he can select the correct proponent and i will show the list of filtered data in the listbox under that proponent
combobox showed all proponents without filter
and on selecting any proponent list box filtered the data
i add a text box which shows the security level of login user on executing this form i.e one user login and his security level is "1"