Do not trust the navigation bar number to be the same everytime for a given
record.

If the table is indexed and you updated a field in the index it can display
the records in a different sequence.

"laks" wrote:

Hi,

We have an application in MS Access, i am searching for a record using
below code

if Me.Dirty then Me.Dirty = false

With Me.RecordsetClone

.FindFirst "[DrawingNumber] = """ & Me.DrawingNumberSearch & """"

If .NoMatch Then
MsgBox ("Drawing Number" & Me.DrawingNumberSearch & "is not
available")
Me.DrawingNumberSearch.Value = ""
Else
Me.Bookmark = .Bookmark
Me.DrawingNumberSearch.Value = ""
End If

End With


we have huge data in the database
(around 100000) when i search for 50000 record, it is displaying the
correct data, but when i update it is updating the different record
which shows in navigation bar (Previous, first, next, last).

Anybody can help in this??.This application is in live.

Thanks in advance.