Can't use Find or Replace now.

macattack

Registered User.
Local time
Yesterday, 22:23
Joined
Jan 5, 2013
Messages
35
I am having a hard time figuring this one out. I created a button on my report to search through the report and it worked fine. I made a boatload of changes and now I can't get it to work. I have no clue why, as there were no changes to the report that I can remember (other than making the recordsource of the form change based on what buttons were clicked on another form). The first search works, then I get a message about not being able to use Find or Replace now (see picture).

The code for the button is just:
Code:
Private Sub Find_Click()
Me.AvionicsTime.SetFocus
DoCmd.RunCommand acCmdFind
End Sub

Also, the find window drops behind the popup report and access says, "Search succeeded" in the bottom left corner of my screen...but I'm not done searching!:banghead:
 

Attachments

  • Find or Replace.jpg
    Find or Replace.jpg
    26.1 KB · Views: 143
Last edited:
Ok, the true source of the issue (since it reared its head again): To many characters on a report?!? When I went and deleted my "stress test" entries in the database I am able to search just fine. Is there some way to deal with acCmdFind not liking too many characters on a report?
 
Last edited:

Users who are viewing this thread

Back
Top Bottom