I have 2 combo boxes which can be used to set an employee's availability and Salary type on an employees form in access.
I have sub which changes availability to “Full time”, if the salary type is “Retainer” ;but when I do this I keep getting Error 2115 : The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Access from saving the data in the field
I have sub which changes availability to “Full time”, if the salary type is “Retainer” ;but when I do this I keep getting Error 2115 : The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Access from saving the data in the field
Code:
Private Sub SalaryType_Click()
SalaryType.SetFocus
If SalaryType.Text = "Retainer" Then
Availability.SetFocus
Availability.Text = "Full Time"
End If
End Sub
Comment