求助:循环判断记录字段是否为空报错
求助各位:帮我看看下面语句中Rs2(F)应怎样表示,来判断为空,F是变量
读取记录,记录有工序1到工序10字段,需要判断他是否空,但运行到“If Rs2(F) Is Null Then”报错,要求对象
Dim Rs2 As New ADODB.Recordset
Rs2.CursorLocation = adUseClient
Rs2.Open "SELECT * FROM tabWK_Plan WHERE ID=" & Rs1("来源号2"), Conn, adOpenKeyset, adLockOptimistic
If Not Rs2.EOF Then
Dim i As Integer
Dim F As String
i = 1
Do While i <= 10
F = "工序" & i
If Rs2(F) Is Null Then
End If
i = i + 1
Loop
End If
我分不多,请各位帮助