Search record is finding another record when using findfirst
Hi,
It is updating the record which it was showing in the Navigation bar.
I have on the SQL profiler and checked.
Thanks and Regards
KARL DEWEY wrote:
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.
|