SendKeys causes a debugger interruption in Windows 7. I posted the
message below to Windows 7 group, and got sympathy, but no solutions
to the problem. Is there an Access command other than SendKeys{f4}
that will cause the drop-down list to appear? Thanks.
---------------------
The following command failed when used in Access 2003 running on
Windows 7:

SendKeys "{f4}" ' causes drop-down names list on hitting first key

It causes the debug window to open, which the user cannot deal with..
This command has worked for 12 years in Access 95, 97, 2K, and 2003,
running on Windows 95, W98, W2000, WMe, WXP, and Vista. But on a
laptop running W7, it failed. Any idea why? And, BTW, actually
manually pressing the F4 key does work properly.
Pete Brady

"Paul Brady" <ptbrady (AT) aol (DOT) com> wrote


I can't get to Access now, so am unable to easily look this up.

One of the methods of the listbox/combobox control will open the
drop-down.

Over the years I've noticed that many of the regulars here strongly
discourage using sendkeys at all .... one reason is that you have no
control over focus; and ocassionally sendkeys will issue a command to
the wrong window.

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)

"Paul Brady" <ptbrady (AT) aol (DOT) com> wrote

Me.MyCombo.DropDown

On Wed, 19 Oct 2011 18:27:12 +0100, "Stuart McCall"
<smccall (AT) myunrealbox (DOT) com> wrote:

Stuart, thank you. That nearly worked, but it was then OK when I
changed it to Combo36.DropDown (Combo36 is the name of the control.)
However, it worked on my ancient computer with A2K and WindowsMe.
It will be a few weeks before I can try it with Windows*7, but I think
it will work. Thanks again.