Help for VBA-Access 2000 beginner, editing variables

[peggym]

Given that the table "TableName" is open and at the first record:

1. How do you place the value in the field "FieldName" into the VBVariable "OldData"?
2. How do you replace the value in Field FieldName with the VB Variable "NewData"?
3. Possible to find the answer to this and other questions though the VB Help Files?

 

[jrbarnett]

Look up the Recordset object in the help files. You can read data, update and delete it.
It's not always the fastest way of doing things though, but is a good start and will keep you going until you feel you are are able to experiment more.

John