find record searching ..continues to search

[chaft]

I have been able to get my code to run after each find search from the find records box but now I can't get it to stop running even when i'm not searching. I've tried a few IF statements to curtail it's use but if you have any suggestions that would be neat.

The main problem I'm having now is that after searching for say a 'surname' from 'find records' reaches the end of the recordset and there are no more of that name to search for; the process comes to a halt and I have to press ctrl break to get my database back. I include a picture of the error that happens after I have to break the code and the 'calculating' text that appears indefinitely at the bottom never ceasing until i break the code.

Any ideas why this is happening and what i can do to stop it?

the end result of ctrl break

http://download.yousendit.com/EC84BFF92A622D49

 

[Remou]

Please post your code.

 

[chaft]

SendKeys "%h,a,%n"
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

 

[Remou]

Are you using Access 97? If not, which version are you using?

 

[chaft]

access 2000

 

[Remou]

I am afraid the keys you posted don't seem to work for me. Alt+h brings up the help menu. Have you considered running the code from a command button?

 

[chaft]

It was an error in my currentrecord event property for the form that was causing this problem. Now I can use Find and replace box which works great for my purposes.