SendKeys Macro

[JR]

How does one type the "CTRL" key and Function key using the Sendkeys??...
I'm trying to requery a form, and have tried the Requery command until I'm
blue in the face... I can occasionally get it to work if I run the requery
macro multiple times...

however, by pressing the CTRL+F7 key the form quickly requeries and
refreshes with no problems... therefore I want to create a macro that does
this (I'm not a coder.. the macros are easier to learn).

Thanks
JR

 

[Steve Schapel]

JR,

I believe it would be ^{F7}

I can't think what the problem with the Requery macro might be, but
sorry too hear about the blue face. However, please be aware that there
are a number of inherent problems with SendKeys, and most Access
developers would regard it as something to avoid.