如何实现参数化查询

[ccyylib]

我用ACCESS建立了一个数据库,现在想建立一个参数化查询表单,在表单的文本输入框中输入查询值如"Fieldname1 like "王%" 按查询按钮则系统会检索出 Fieldname1字段中以"王"开头的记录.请问这该如何实现.我用过JAVA,它有参数化查询的功能不知道在VB中是如何实现的请网友帮忙谢谢

[zqfleaf]

sql="select * from table where " & text1.text "

[射天狼]

Dim rs As New ADODB.Recordset

rs.Open "select * from name like '王%'", cn, adOpenForwardOnly, adLockReadOnly

[zqfleaf]

sql="select * from table where " & text1.text

[xayzmb]

sql="select * from table where fieldname like '" & text1.text & "%'"

[didishu0807]

rs.Open "select * from name like ('"王"'+ '%')", cn, adOpenForwardOnly, adLockReadOnly