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