OK Every posting I'm reading on this states that you should Set Key
Preview to Yes on the form, then place the following code into the
KeyDown even: If (KeyCode = vbKeyDown Or KeyCode = vbKeyUp) Then
KeyCode = 0

Additionally I also have this code on a combo on the form:
If KeyCode = vbKeyDown Then SendKeys "{F4}", True

Seems simple enough, yet it is not working. If I set Key Preview to NO
the the combo code works but the record movement on Up/Down is active
and I do not want this.

I'm using Access v10.

Any help on might be happening here would be appreciated.

Thanks in advance,
--FB

Hi

Your problem, I think, is caused by the fact that you are using vbKeyDown
for 2 different actions. When the first event (Form KeyDown) detects the
down arrow your first bit of code runs - and sets KeyCode to zero. The
combo KeyDown never has a chance to fire cos the keycode has already been
set to zero.

Using a different key to drop the combo seems to be the simplest work
around, although I accept that this won't be as intuitive.

HTH

Jeff Bailey

"FrankBooth" <acg_acg (AT) hotmail (DOT) com> wrote