[X]My Assistant

[boriss]

We have been using 2016 for several months -
Have an new interesting problem:
Primary Key AutoNumber IDs are disappearing. They never had any data in them, just blanks.
I know you can not get them back. I personally do not have this problem as I am the administrator.
It occurs when someone else searches a form, we never had this problem before .... Trying to see what this person is doing - no luck yet.
Is there a way to prevent this ?????

Thanks !!!!!!

[FrankRuperto]

Maybe users begin adding a record in the form and abort the operation. Autonumbers are reserved the moment a user begins adding a new record. Would need more information about the form.

[GroverParkGeorge]

It sounds like your search form is somehow creating a new record when someone conducts a search.

HOW does the search work?

There are at least a couple of ways to make this happen. If you use a combo box to select a record and use the after update event of that combo box to filter the form's recordsource to that record, that combo box must NOT be bound to a field in the form's recordsource. If it is, that can cause this problem.

Another way to cause it is to use a default value in a field that causes the form to create and SAVE a new record whenever you simply move the form to a "new record" using one of the built in ways to do that.

[boriss]

I have seen them do this .... it creates the ID with a blank record shell. The ID doesnt disappear........

[boriss]

What I just found out was the field she was searching. In that field there are only Mouse Down / Mouse Up instruction.... nothing to do with updates. Just something to show them Table/Control names so they know what to use in creating their queries

Private Sub WaterBodyName_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)

Dim varReturn As Variant

varReturn = SysCmd(acSysCmdSetStatus, "ReportTable [WaterBodyName]")

End Sub

This is the field she was searching by the way. Could this simple command trigger a new record then delete it ????

[GroverParkGeorge]

It is highly unlikely that it would be deleting records, but we can't actually see the form in action.

[boriss]

Thanks for the input .... I am meeting with the girl this morning to see if I can zero in
Will post back if I find resolve

Thanks for the help - so far !!!!