Sorry if this is a silly question...I am a new user. I'm adding a field to a
form, and when I enter information into it, the same information carries from
one record to the next. How do I correct/prevent this?
I am using Access 2003 if this helps at all.

It sound like the field in the form is not bounded to a field in the Table
(The record source of the form), check the control source of the field, if
its empty click on the right and select the right field name form the field
list that declared in the form record source

--
\\// Live Long and Prosper \\//
BS"D


"Sandi" wrote:

> Sorry if this is a silly question...I am a new user. I'm adding a field to a
> form, and when I enter information into it, the same information carries from
> one record to the next. How do I correct/prevent this?
> I am using Access 2003 if this helps at all.

sounds like you added a *control* to a form. if you want data entered in the
control to save to a field in the form's underlying table, you need to make
sure the table's field is included in the form's RecordSource, and then bind
the control to the correct field by setting the control's ControlSource to
the name of the field.

hth


"Sandi" <(E-Mail Removed)> wrote in message
news:F3C9DAAC-B2F5-4D08-89F9-(E-Mail Removed)...
> Sorry if this is a silly question...I am a new user. I'm adding a field to
a
> form, and when I enter information into it, the same information carries
from
> one record to the next. How do I correct/prevent this?
> I am using Access 2003 if this helps at all.

Are you sure it is not simply displaying a default value? Have you looked at
your form and corresponding table in design view to ascertain whether a
default value is specified for the particular control or field? If none,
then you might need to open your form's code module and peruse the event
procedures to determine why the value is showing in your control.

Brian


"Sandi" <(E-Mail Removed)> wrote in message
news:F3C9DAAC-B2F5-4D08-89F9-(E-Mail Removed)...
> Sorry if this is a silly question...I am a new user. I'm adding a field to
a
> form, and when I enter information into it, the same information carries
from
> one record to the next. How do I correct/prevent this?
> I am using Access 2003 if this helps at all.