I have a form  frmEmployeeNewAttendance   based on a table  Vacation_Table  that has an event procedure to calculate a vacation accrual based on Employee Type [EEType].  Currently [EEType] is included in the underlying table, but I would like to clean up duplicate fields and remove this field from Vacation_Table and use the field that is in the table  Employee_Master  also called [EEType].  How do I reference the [EEType] in the table  Employee_Master  in the below event procedure that is in the form  frmEmployeeNewAttendance ?

Private Sub CurrentYrVacationAccrual_Enter()
    If ([CurrentYr] - [EmploymentYr]) >= 15 Then
        [CurrentYrVacationAccrual] = 25
    ElseIf [EEType] = "FF" Then
        [CurrentYrVacationAccrual] = 10
    ElseIf [EEType] <> "S" Then
        [CurrentYrVacationAccrual] = 25
    ElseIf ([CurrentYr] - [EmploymentYr]) = 0 Then
        [CurrentYrVacationAccrual] = [1stYrVacationAccrual]
    Else
         [CurrentYrVacationAccrual] = 20
        
    End If