How do I edit a field in my table

[avatarp]

I have a table that I scan rows then,the columns to match a column header with a variable. Once the column has been found with correct header, I want to change the value of the cell in that row.

This is my sample With statement to do this:

With rsMyRS
.Edit
!EmailList = True
.Update
End With

EmailList is the column header and I am setting the value of this cell to be 'True'

This is my problem how do I do this with the column header name stored in a variable. I have to use a variable because I have many possible column headers. So I need something generic.

Thanks for your help.

 

[johnwm]

try this:

If you know that the fieldname is EmailList use:

.fields("EmailList&quot = True

If the field name is stored in myStr use:

.fields(myStr) = True Let me know if this helps
________________________________________________________________
If you are worried about how to post, please check out FAQ222-2244 first

'There are 10 kinds of people in the world: those who understand binary, and those who don't.'