repetition problem

[Lara Nelson]

After using the wizard to set up a database (employment
database). I tried to add another field for "notes".
However what is happening is that when I add notes to one
person's 2nd notes field, thesame message is in
everyone's. However can I unconnect this?

Thanks
Llara

 

[Rick Brandt]

After using the wizard to set up a database (employment
database). I tried to add another field for "notes".
However what is happening is that when I add notes to one
person's 2nd notes field, thesame message is in
everyone's. However can I unconnect this?

Sounds like you didn't actaully add a field to the Table, but just stuck an
additional control on the form. A control that is not bound to a field in the
underlying table will not save its data anywhere. It is just text sitting on the
form with no "attachment" to any specific record and will in fact vanish when you
close the form.

If you add a second note field to the table and then set the name of that field as
the ControlSource property of the new control on the form, then it should swork as
expected.