Option Group And Combo Box Dilemma

[DGagnon819]

Resident Experts,
I am currently working on a database to track the employee training for my company. Access is the only tool that is available and I'm definitely a novice. I'm working on a form to enter training event information and I have an option group and combo box problem. How can I disable a combo box until a certain option is selected?

I had made a database earlier for this customer but I worked with no process and so therefore I did the best I could. However, the customer has brought something to my attention that needs correcting.

The problem is that although the current database does record training events it doesn't produce reports which show what the employee hasn't done.

Because there are training events that pertain to everyone and then there are events that only pertain to individual employees based off of a 'job code' (which identifies their specialty) I've struggled to establish a link between employees and these two different types of training.

In an effort to correct this problem, I've added a 'project mandatory code' to the 'EmployeeInfo' table which holds all employee information along with their job code. Each time a new employee is entered into the table, a default value is entered into the project mandatory row.

I have seperate tables called 'JobCodes', 'ProjectMandatoryCode', and 'TrainingEventFrequency' which are connected to my 'TrainingEventInfo' table. The TrainingEventInfo table holds the information for all known events.

When a new training event is recorded, an entry is made into my 'CompletedTrainingRecord' table. This table records the event name, date completed, and the employee clock number.

Although I think my logic is sound, I may have missed something and made no progress at all.

Having said all that, the form I am working on to enter training events into the TrainingEventInfo table is where my original question came in. The option group I have has two choices: Project Mandatory Training and Position Related Training. If the user selects Project Mandatory Training then I want the combo box to be unavailable and based off the value it will automatically input a default value for the ProjectMandatoryCode. If the user selects Position Related Training from the option group I want the combo box to become active. My combo box is run from a query which pulls the job codes from the appropriate table and this value can then be written to the record in the TrainingEventInfo table.

Because both the ProjectMandatoryCode and the JobCode are in the EmployeeInfo table I'm hopeful that I can write a query which will pull all events, related to the individual, whether they have been completed or not.

Thank you in advance for any assistance you may be able to provide. I've attached a document which may be helpful. Respectfully,
Dale Gagnon

 

[mhartman]

Hello:
The below code disables a combo box named cboMonths if the selected value in the option group named optCompleted is not 1. Otherwise, it leaves the combo box enabled
'
Regards
Mark
'
Private Sub optCompleted_AfterUpdate()
If optCompleted.Value = 1 Then
cboMonths.Enabled = False
Else
cboMonths.Enabled = True
End If
End Sub

 

[DGagnon819]

Thank You!

Mark,
Thank you for the help. I followed your instructions and it worked like a champ. I was concerned that the combo box was still available before a button was selected and I tried modifying the statement to include a Null possibility. Eventually I set the combo box 'enabled' setting to 'no' and now its greyed out until the user selects the appropriate button.

Thanks again and if you're a father please have a happy Father's Day.
Dale Gagnon

 

[mhartman]

Hello
Thank you very much, and a happy father's day to you as well.

The routine above can also be modified and placed in the FormOpen event to "Initialize" your form to a certain state. After that the initial control events then can modify that form state.
Regards
Mark