docmd.SendKeys "{F9}" in 2007

[RickM]

Does anyone know the equvilent of docmd.SendKeys "{F9}" in 2007?
Thanks

[genesis]

do you still need the answer. I can see that you have already ticked this post as SOLVED. So I guess you already solved your problem.

[RickM]

Thanks for the reply. I finally figured it out, though it took hours of trying.

[genesis]

good for you. maybe you would want to share to the whole community the solution you came up to your problem so others may also benefit.

cheers

[RickM]

I used DoCmd.RunCommand acCmdRefresh
on AfterUpdate event
That is the same as hitting F9 refresh

That's everyone..... This place is the best!