whats the difference in this

[asc4john]

I discovered I can do this:
dim rst as RecordSet
rst!someField = "some value" instead of this
rst.Fields("someField") = "some value"
Is there a difference between thre two? Is there a reason to use one
method and not the other?

 

[Douglas J. Steele]

Realistically, they're equivalent.

A good reason for using the second syntax is that it allows you to use a
variable for a field name, while that's not possible using the first syntax.

 

[Steve Schapel]

... it allows you to use a variable for a field name

.... as also does:
rst("someField")