DAO Errors after converting from Access 97 to 2002

[Dave]

I converted a database from access 97 to access 2002 and I
am now getting compile errors due to old DAO syntax. I
have changed some of the code to work correctly but the
following code I can't seem to change so that it works.

Forms![frm_OT].Dynaset.MoveFirst
Forms![frm_OT].Dynaset.Edit
Forms![frm_OT].Dynaset.Dynaset.fieldName = " "
....
....
....
Forms![frm_OT].Dynaset.UPDATE


I am trying to clear the data from the fields. Wondering
if someone knows how to properly convert this code.

Thanks Dave

 

[Douglas J. Steele]

If you still have your copy of Access 97 (or, more specifically, the help
file from it), look up "obsolete features in DAO", and you'll see Dynaset
listed there.

Use Recordset instead.

 

[david epsom dot com dot au]

Forms![frm_OT].Dynaset.MoveFirst

That looks like
Forms![frm_OT].RecordsetClone

(david)