Using Microsoft FIND in Access causing form to freeze...

[Sonarman2]

I have a form set up for editing member information. One function is set up to find a record using any field. Often (50% ??) the form will freeze after finding a requested record. The following is the VBA..
Private Sub Find_Member_Click()
On Error GoTo FindRecord_Click_Err

DoCmd.RunCommand acCmdFind
FindRecord_Click_Exit:
Exit Sub



FindRecord_Click_Err:
MsgBox Error$
Resume FindRecord_Click_Exit
End Sub

Seems simple enough. Has any one seen this behavior? Also at times after the freeze, the form starts to scroll up eventually returning to the first record. No linked tables are used with this form Records are sorted on Lastname, Firstname. Nothing fancy. It is not a large database, 2300 records each with 25 fields.

I am looking at using a "Find" method using VBA without the system find function, creating my own Find Form. I have a version working that is used to locate groups of records based on 1 of 8 fields (field has to be selected prior to search).

I am quite a novice here, learning on my own (age >> 65).

Thanks
S0narman2

[ranman256]

Dont use FIND. Use a select query. (its faster anyway)

[June7]

I've never used acCmdFind.

Example code I use to find record on form:

Private Sub cbxCommunities_AfterUpdate()
'Find the record that matches the control.
Me.RecordsetClone.FindFirst "Community = '" & Me.cbxCommunities & "'"
If Not Me.RecordsetClone.EOF Then Me.Bookmark = Me.RecordsetClone.Bookmark
Me.cbxCommunities = Null
End Sub

However, that is only for search on a single field. I have used comboboxes and textboxes and lots of VBA code to build a utility for searching on any field and/or combinations of fields.

An alternative to RecordsetClone and bookmarks is to set form Filter and FilterOn properties.

[ItsMe]

I use DAO to create a clone of the form's recordset and then Bookmark.
https://www.accessforums.net/forms/f...tml#post225865

[Sonarman2]

"Find" problem solved. Bookmarks and "FindNext" was the solution. Thanks for all your replies.

Sonarman