Problem w/String name for a recordset field

R

rs0905

I am using a string name to refer to a field in a table. When I plug it into
the code, it is not being recognized as a field. I tried to use a Field
object, which also didn't work. Here's the code:

With rs
.Index = "CounselorID"
.Seek "=", Val(strCounselor)
If .NoMatch Then
.AddNew
!CounselorID = strCounselor
!CategoryIdentifier = intCategory
![(insert string field name value here)] =
rsFindWrong![(insert string field name value here)]
![(insert string field name value here)] =
rsFindWrong!CountOftxtMID
.Update
Else...
End IF...
End With...

What should I insert in the brackets to make this work, assuming the string
field names are strField1 and strField2?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top