现在在制作员工信息窗口,在员工信息窗口上方(见附件)增加查询窗体,查询内容主要有工号,姓名,分管领导,评估人,职级这五项(对应人事信息表中也有这五列),希望通过手工录入这五项,按查询按钮就可以查到对应的人员,同时希望五项查询内容中任意录入其中一项都可以执行查询操作,设置语句如下,无法执行查询,请版主指导:
Dim gh As WinForm.TextBox = e.Form.Controls("工号")
Dim xm As WinForm.TextBox = e.Form.Controls("姓名")
Dim fg As WinForm.TextBox = e.Form.Controls("分管领导")
Dim pg As WinForm.TextBox = e.Form.Controls("绩效评估人")
Dim zj As WinForm.ComboBox = e.Form.Controls("职级")
Tables("人事基本信息表").Filter="工号= '" & gh.Text & "' and 姓名= '" & xm.Text & "' and 分管领导= '" & fg.Text & "' and 绩效评估人= '" & pg.Text & "' and 职级= '" & zj.Text & "' "