Subject: Combo-box with values per department

[bamerand]

Dear all,



I need assistance in providing guidance and assistance in the following database (I am a newbie with VBA and queries). I have attached the <Personnel.zip>*and here is a description of the purpose of the DB and what I cannot accomplish and called for your expertise.

The DB is made of 2 tables, those are <Personnel> and <Trainings>, 2 forms, those are <Personnel List> and <Personnel Details>. The <Personnel Details> form consists of two tabs, one is called <General Information>, which contains overall information about employees. The second tab, with which I am having difficulties, is called <Training information>.

I need to have the <Training information> tab, which is sub-formed with <Trainings> table, to be in continuous combo-box, i.e. for each created employee (the sample contains 4 employees) I need to have the field <Training title> in the combo-box field by department field. Like, if value <HR> is selected in the <Department> field, then the combo-box should list the values that are <Internal Auditor Course> and <Lead Auditor Course>, or if selected value <Maintenance> in <Department> field, then the combo-box should list values that include <Basics in instrumentation>, or if selected value <Construction> in <Department> field, then combo-box should list values that include <Intensive English>. What I was able to accomplish is the <Trainings> table is sub-formed to <Training information> tab and I can physically type the values for each of the trainings attended by all employees (over 2,000 in total).

The second issue I have is I need to make inactive cells <Issued date> and <Valid date> if the <Permanent> field is checked-in. Alternately, if the <Permanent> field is checked-out, then the cells <Issued date> and <Valid date> should become active.

I look forward to receiving any support, recommendations, if you have code / DB that has similarities, please post along.

Link to the DB.

https://www.dropbox.com/s/cof8hfnt1o...onnel.zip?dl=0

[June7]

Sounds like dependent (cascading) comboboxes. Review http://www.datapigtechnologies.com/f...combobox2.html

Is Trainings table for documenting training done by employees?

Seem to be missing table to serve as a lookup for training courses.

Use Conditional Formatting to manage 'inactivation' of textboxes (not 'cells').