凑个热闹
第一个问题:
Me.Filter = "[Name] Like '*' & forms![contact]![text37] & '*' AND [Company] Like '*' & forms![contact]![text34] & '*'"
Me.FilterOn = True
第二个问题:
Private Sub 组合框_NotInList(NewData As String, Response As Integer)
Dim db As Database
Dim strSQL As String
strsql = "Insert Into 表名 (字段名) Values & "(" & """" & NewData & """" & ")"
if MsgBox( "没有此内容,是否添加到字段列表中?", vbYesNO, "添加新内容")=vbYes Then
Set db = CurrentDb
db.Execute strSQL
Response = acDataErrAdded
Set db = Nothing
Else
Response=acDataErrDisPlay
End If
End Sub
[此贴子已经被作者于2005-6-3 16:16:24编辑过]
|