1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| Private Sub FltOffice_Enter()
If Me.Filter = "" Then
FltOffice.RowSource = "SELECT DISTINCT 3Office, 2Bureau FROM Tb_Survey order by 1,2;"
Else
FltOffice.RowSource = "SELECT DISTINCT 3Office, 2Bureau FROM Tb_Survey WHERE " & Me.Filter & " order by 1,2;"
End If
End Sub
Private Sub FltBureau_Enter()
If Me.Filter = "" Then
FltOffice.RowSource = "SELECT DISTINCT 2Bureau, 0Parent FROM Tb_Survey order by 1,2;"
Else
FltOffice.RowSource = "SELECT DISTINCT 2Bureau, 0Parent FROM Tb_Survey WHERE " & Me.Filter & " order by 1,2;"
End If
End Sub
Private Sub FltSection_Enter()
If Me.Filter = "" Then
FltOffice.RowSource = "SELECT DISTINCT 4Section, 3Office FROM Tb_Survey order by 1,2;"
Else
FltOffice.RowSource = "SELECT DISTINCT 4Section, 3Office FROM Tb_Survey WHERE " & Me.Filter & " order by 1,2;"
End If
End Sub
Private Sub FltUnit_Enter()
If Me.Filter = "" Then
FltOffice.RowSource = "SELECT DISTINCT 4aUnit, 4Section FROM Tb_Survey order by 1,2;"
Else
FltOffice.RowSource = "SELECT DISTINCT 4aUnit, 4Section FROM Tb_Survey WHERE " & Me.Filter & " order by 1,2;"
End If
End Sub
Private Sub FltGroup_Enter()
If Me.Filter = "" Then
FltOffice.RowSource = "SELECT DISTINCT 4bGroup, 4aUnit FROM Tb_Survey order by 1,2;"
Else
FltOffice.RowSource = "SELECT DISTINCT 4bGroup, 4aUnit FROM Tb_Survey WHERE " & Me.Filter & " order by 1,2;"
End If
End Sub |
Partager