Hello Experts:
I need a general recommendation for enabling/disabling a control on a form based a query (where the query is NOT the form's row source). Below are more details (general concept):
- Let's say I have a table with 1,000 employees
- On a single form, I have a number of fields (last name, first name, address, etc. etc.)
- Now, out of the 1,000 employees, only a subset of individuals may be considered "leadership". So, let's say only 50 out of the 1,000 employees are considered "leadership".
- Now, all of these 50 employees must complete "leadership training". As of now, however, let's say only 30 completed this training. The other 20 have not.
- A query (including the employee number) reference which 50 employees are part of leadership.
What I need to achieve on my form:
- Now, my form uses a different query as the row source. This query includes the 1,000 employees.
- On my form, I have a field/combo box "Leadership Training Status". The values in this field are either "Completed Training" or "Not Completed Training".
- Now, I only want the combo box (training status) be active for those 50 employees who are considered leadership.
- All of the other 950 employees will show the field but it needs to be disabled. That is, I do NOT want to accidentally change the value to "Completed Training" for any employee NOT part of the 50 leaders.
In summary, how can I enable/disable the combo box based on the employee ID? Again, I may be on record where employee ID = 273. If employee ID 273 is NOT part of query which identities the 50 leaders (not form's row source), I then want to disable the combo box. If current employee record is also part of the leadership query, I want to enable the combo.
I hope this makes sense.
Cheers,
EEH