Results 1 to 1 of 1
  1. #1
    Zedlexx is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2009
    Posts
    1

    Find Record button error

    I am having a bit of a problem when using the find button on a form. When I click the button the search/replace box pops up as below so no problem so far.





    The search works fine on the database, but if you have the search box open and you switch to another application I get the message below. It only happens when you move away from the database with the search window open.



    But have no idea on how to stop it. It looks like it trying to search the new application.

    I am quite new at all this so it might be something silly I have done.

    I have put the code I am using on the button below.

    Private Sub Search_from_edit_Click()
    On Error GoTo Err_Search_from_edit_Click

    Screen.PreviousControl.SetFocus
    DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

    Exit_Search_from_edit_Click:
    Exit Sub

    Err_Search_from_edit_Click:
    MsgBox Err.Description
    Resume Exit_Search_from_edit_Click

    End Sub

    Any idea would be of great help as I am lost?
    Last edited by Zedlexx; 03-13-2009 at 04:49 AM. Reason: Extra info added

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Error "Record is Deleted"
    By koper in forum Access
    Replies: 8
    Last Post: 03-10-2009, 10:20 AM
  2. Find data, load data, and save as a new record
    By hawzmolly in forum Access
    Replies: 0
    Last Post: 10-05-2008, 03:18 PM
  3. can't find language DLL
    By tequila in forum Access
    Replies: 0
    Last Post: 05-01-2008, 09:31 PM
  4. How do I find the serial value of Now()?
    By JoeG in forum Queries
    Replies: 0
    Last Post: 03-13-2007, 08:16 AM
  5. How to Find a Record
    By lschlitt in forum Programming
    Replies: 2
    Last Post: 09-09-2006, 06:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums