Memo fields mess up my database

[hbrems]

Hello,

when I update a form with a new record, that record will copy to any previous record that I click in the same form.

This only happens when I'm adding records to a table that contains a memo field...

Anything I need to keep in mind about memo fields?

Kind regards,
Hans B.

 

[The_Doc_Man]

Memo fields are the bastard step-children of Access, but if they are properly implemented you should not have the symptom you describe.

The behavior you describe sounds almost like you are doing something with an unbound field that isn't reset after a form update. Are you using VBA to do your updates? If so, this is a field initialization error. If not, then I'm not so sure whassup.