>>>>>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???
>>>>
>>>>refresh your form?
>>>
>>>
>>>I am already refreshing the form. any other Ideas on why my pointer will not move to the new record. I have even tried a go bottom, after the insert.
>>
>>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