Hello everybody,

Can anybody help me to make an appendquery? I'm a total newbie, and I want to append a value in a column of an Access table, using a For loop.
It should look something like this:

For Each testfield In ?
Update testdb
Set testfield = ("Hello")
where testfield = "Sabrina"
Next

My questions are:
What should be in the place of the question mark?
Is there anything else wrong with this sub?

Thank you for your time.