> >>>>>>I am trying to add a new record, I can insert the record into the
> table. Although, my record pointer stays on the last record, it does not
> move to the new record that I just inserted. The problem being that when
> you start to key into the controls you are making changes to another
> record. Any Ideas???
> >>>>>
> >>>are your controls bound to the data file?
> >>
> >>Yes, I have the ControlSource set to the field in the table.
> >
> >are you using append blank or insert into... append blank places you in
> the new record -- insert into doesn't
>
> I have tried both, currently I am set up with the insert. I had the same
> results using append blank, that is why I went to the Insert. Although I
> will try append blank again.
If APPEND BLANK doesn't work, then check to be sure that you're on the
right alias. If the controls are bound to one alias, and you add a
record in another alias, then the first alias will not be affected.
/Paul