Changes record when current is saved

M

Matt Sonic

I have a form that any time I save a new record, it looks like the form moves
to another record in the recordset but the number in the record navigation
buttons doesn't change. Also when I scroll the mouse down once after saving
the record the form goes to a new record. But if I scroll back up, I don't
get the record I just added. The record showing isn't even the last record
in the recordset. I get the record that it went to upon saving. The record
I added does save though.

This is how I have it set up. The form is open in edit mode with
Me.AllowAdditions = False
Me.AllowEdits = False
Me.AllowDeletions = True
then the Add button is clicked doing the following
Me.AllowAdditions = True
Me.AllowEdits = False
Me.AllowDeletions = False
DoCmd.GoToRecord , , acNewRec
I put the data in the controls and go to Records in the Menu bar and click
Save Record. When this is done, no code runs because I put break points at
the beginning of all the procedures I have added. The data that is seen on
the form changes to another record. The forms Cycle property is set to
Current Record. Data is linked directly to a table which is linked to a sql
server table.

I have many forms that work like this. This is the only one giving me a
problem. I have had rare times when the forms become corrupt but not like
this. Any help would be greatly appreciated.

Matt
 
Top