7,713
社区成员
发帖
与我相关
我的任务
分享
Private Sub 客户编号_BeforeUpdate(Cancel As Integer)
If MsgBox("您确定更改数据?", vbDefaultButton2 + vbYesNo, "更改提示!") = vbNo Then
Me.Undo
End If
End Sub
Private Sub 客户编号_AfterUpdate()
On Error GoTo 客户编号_AfterUpdate_Err
客户全称.Value = DLookup("客户全称", "客户信息", "客户编号='" & 客户编号.Value & "'")
联系地址.Value = DLookup("联系地址", "客户信息", "客户编号='" & 客户编号.Value & "'")
联系人.Value = DLookup("联系人", "客户信息", "客户编号='" & 客户编号.Value & "'")
邮编.Value = DLookup("邮编", "客户信息", "客户编号='" & 客户编号.Value & "'")
电话.Value = DLookup("电话", "客户信息", "客户编号='" & 客户编号.Value & "'")
客户编号_AfterUpdate_Exit:
Exit Sub
客户编号_AfterUpdate_Err:
MsgBox Error$
Resume 客户编号_AfterUpdate_Exit
End Sub
Public Sub ComboBoxAppend(ByRef srcCtl As ComboBox, ByRef NewData As String, ByRef Response As Integer)
Dim adoConn As ADODB.Connection
Dim adoRs As New ADODB.Recordset
If MsgBox("您输入的值不在列表中,是否要添加到列表?", vbOKCancel) = vbCancel Then
Response = acDataErrContinue
srcCtl.Undo
Exit Sub
End If
Select Case srcCtl.RowSourceType
Case "Value List":
srcCtl.RowSource = srcCtl.RowSource & ";" & NewData
Case "Table/Query":
Set adoConn = CurrentProject.Connection
adoRs.Open srcCtl.RowSource, adoConn, adOpenDynamic, adLockOptimistic
adoRs.AddNew
adoRs(srcCtl.BoundColumn - 1) = NewData
adoRs.Update
adoRs.Close
Case "Field List":
Set adoConn = CurrentProject.Connection
adoConn.Execute "ALTER TABLE " & srcCtl.RowSource & " ADD COLUMN " & NewData & " Text"
End Select
Response = acDataErrAdded
End Sub
Private Sub Combo0_NotInList(NewData As String, Response As Integer)
ComboBoxAppend Combo0, NewData, Response
End Sub