rs.field question

[dominiopt]

why this variable definition are failing ?

If Combo1.Text = wd1 Then
dbCampo = "Secção"
End If

Set rs = db.OpenRecordset("SELECT * FROM " & dbTabela & "&quot
Do While Not rs.EOF
'record = "" & rs!Fields("dbCampo&quot ---> This gives error
'record = "" & rs!Secção '-------------> This works fine
If record <> &quot;&quot; Then
List1.AddItem record
End If
rs.MoveNext
Loop
rs.Close

Thanks
Fernando

 

[dpaulson]

record = &quot;&quot; & rs(&quot;dbCampo&quot ---> change to this David Paulson

 

[abdullauthan]

make it...
record = &quot;&quot; & rs.Fields(&quot;dbCampo&quot

 

[dominiopt]

Thanks to all helping people.
Fernando