1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Private Sub inst_AfterUpdate()
Dim vb_tba As String
Dim finst As String
stEmpName = Nz(DLookup("[tba]", "[nbr_per_inst]", "[institution]= '" & Me.inst & "'"), "")
If vb_tba = "" Then
MsgBox "pas de congés pour cet institution"
Me.[nbrofleave] = 0
Me.tofday = 0
Cancel = True
Else
Me.[nbrofleave] = vb_tba
Me.tofday = DLookup("[bna]", "[nbr_per_inst]", "[institution]= '" & Me.inst & "'")
End If
finst = "select * from groupe where ([institution] = '" & Me.inst & "') "
Me.leaveseloninst.Form.RecordSource = finst
Me.leaveseloninst.Form.Requery
End Sub |
Partager