How to access individual fields within a record

[GlennG]

Hello all,

For the life of me, I cannot find information on how to modify individual fields within a record by using VBA. I know how to find the record but not how to select a field, modify it and store it back.

Could someone give me a simple example....

Many thanks.... ray:

 

[bat17]

Look up the "Update Method" in help. there is a good example there using the Nothwind Database.

Peter