whats the difference in this

A

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?
 
D

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.
 
Top