Can I auto run a query while inputing data inside a form?

O

oldrog

I have a database to track database user security requests. It have 4 tables:
Users, security roles, departments, and a detail table to tie the other
tables together. I am creating a form to input requests for security roles
into our financial system. The form will display the users name and then
several check boxes listing the different security roles available. There are
certain roles that can not be combined. Such as if you enter a Purchase
Orders you can not be a Purchase Order approver. What I would like is when
one choice is made, to check to and see if there is other security roles
that cannot be combined with the chosen one and then gray them out and make
them unavailable to choose.
 
Top