# Re: 简单的FindFirst问题

Posted by AndyLin on September 10, 1998 at 14:06:00:

In Reply to: 简单的FindFirst问题 posted by JEFF on September 10, 1998 at 09:01:44:

: 我的开发工具是vb6.0和Access97我想利用三个TEXT来输入条件
: 查询我所要的资料程式如下

: Qry = "学生姓名 + " = '" + Field1.text +"AND'"+ 班级 +" ='"+ FieldA.text +"AND'"+ 收费名称 +"='"+ FieldB.TEXT"

: PublicData1.Recordset.FindFirst Qry

: 程式对吗

正确写法应该是: Qry = "学生姓名 = '" & Field1.text & "' AND 班级 ='" & FieldA.text & "' AND 收费名称 ='" & FieldB.TEXT & "'"

Follow Ups: