1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Public Function CtlPlusO()
Dim strObjet As String, fm As Access.Form, strID As String
On Error Resume Next
strObjet = Screen.ActiveDatasheet.Name
On Error GoTo 0
Select Case strObjet
Case "Clients"
Set fm = Screen.ActiveDatasheet
strID = fm.Controls("Code client").Value
DoCmd.OpenForm "fmClients", , , "[Code client]='" & strID & "'"
Case "Commandes"
Set fm = Screen.ActiveDatasheet
strID = fm.Controls("N° commande").Value
DoCmd.OpenForm "fmCommandes", , , "[N° commande]=" & strID
End Select
End Function |
Partager