If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Search record is finding another record when using findfirst
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"Next Record If", Mail Merge Issues | [email protected] | Mailmerge | 8 | February 8th, 2006 07:11 PM |
Press Release - New Search Engine Debuts Features | [email protected] | Powerpoint | 0 | December 17th, 2005 11:35 AM |
Press Release - New Search Engine Debuts Features | [email protected] | General Discussion | 0 | December 17th, 2005 11:28 AM |
Access Mail Merge to Word.doc files ? | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 18th, 2005 06:31 PM |
Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |