Help with runtime error 2115

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • napstar
    New Member
    • Nov 2006
    • 55

    Help with runtime error 2115

    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

    Code:
    Private Sub SalaryType_Click()
      SalaryType.SetFocus
      If SalaryType.Text = "Retainer" Then
        Availability.SetFocus
        Availability.Text = "Full Time"
      End If
    End Sub
    Last edited by NeoPa; Jul 24 '07, 08:23 PM. Reason: Please use [CODE] tags
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32662

    #2
    What type of controls are [SalaryType] and [Availability]?

    Comment

    Working...