event after find record?

[wene]

Hello alltogether!

After searching a lot, I think this is a new question: I'm using the standard find form in Access 2003:

DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Now I want to recalc the form after finding or at least after closing the the find/replace dialogue, but I can't figure out to use the correct event

Cheers,
Werner

 

[HiArt]

Well, you could intercept the event OnFocus (or whatever) so that you trigger some code when your form gets the focus back. However this will trigger every time the form gets focus, so before calling find/replace set a global flag so you can test that the form is getting focus after the required activity. remember to unset the flag afterwards!