请教:Like在代码中如何应用?

zhowgx

<>      我在用窗体做模糊查询时,在窗体数据源中的SQL语句中条件如下:</P>
< ><FONT face="Times New Roman">             (</FONT>用户信息<FONT face="Times New Roman">.</FONT>详细地址<FONT face="Times New Roman">) Like [Forms]![</FONT>用户清单<FONT face="Times New Roman">]![</FONT>地址<FONT face="Times New Roman">] &amp; "*")</FONT></P>
< ><FONT face="Times New Roman"></FONT> </P>
<P ><FONT face="Times New Roman">可以对用户信息表中详细地址作模糊查询;然而将此语句写入窗体的Recordsource运行时出错;不知应如何写.</FONT></P>
<P ><FONT face="Times New Roman">     特此请教.</FONT></P>

方漠

<>TRY:</P>
<><FONT face="Times New Roman">"......Like '*" &amp; [Forms]![</FONT>用户清单<FONT face="Times New Roman">]![</FONT>地址<FONT face="Times New Roman">] &amp; "*'")</FONT></P>