Hi,

I'm using a DAO data control to connect from VB5 to Access 97 using a dynaset type recordset.

On using the AddNew method the new record is being added over the top of the current record.

This results in the old record being lost when the new record is saved and therefore, no matter how many entries I add, I have only one record in my database.

What am I doing wrong?

Any help would be much appreciated.

Best Regards,

Rob Brown.