Private Sub Text8_Click()
If Me.Combo6.Value = "consignment" Then
Me.sub_delivery.Form.Filter = "where sub1.consignment like """ + Me.Text8.Value + """"
Me.sub_delivery.Form.FilterOn = True
Else
Me.sub_delivery.Form.Filter = "where sub1.Order =" + Me.Text8.Value
Me.sub_delivery.Form.FilterOn = True
End If
End Sub
==================================
Run-time error '94':
还是下不下来。
还是按我上面说的方法。不过我觉得最好是加一个按钮,为“开始搜索”,否则在textbox里每打一个字就会进行一次过滤也不好。
在这个按钮的click事件里写代码:
if me.combobox1.value="consignment" then
me.sumform_1.form.filter="where consignment like """
+me.textbox1.value+""""
me.subform_2.form.filteron=true
else
me.sumform_1.form.filter="where id ="+me.textbox1.value
me.subform_2.form.filteron=true
end if
下不下来。你的说法与搜索没有关系呀,好象只是进行录入检核哦。
是不是要根据这个东东来对子窗体进行过滤?
这样写:
me.sumform_1.form.filter="where name like """+me.textbox1.value+""""
me.subform_2.form.filteron=true