Trap key-strokes???

[Niklas Östergren]

Hi!

Is there any way to trap key-strokes in VBA? Or do I have to use macro for
that?

I would like to open up a form filtered depending on which record that have
focus in a datasheet form.

TIA!
// Niklas

 

[Niklas Östergren]

Sorry I forgot:

Offcourse I would like to use <Enter> key to open teh filtered form!

// Niklas

 

[Ronald W. Roberts]

Hi!

Is there any way to trap key-strokes in VBA? Or do I have to use macro for
that?

I would like to open up a form filtered depending on which record that have
focus in a datasheet form.

TIA!
// Niklas

Check Help for the events OnKeyUp, OnKeyDown, and OnKeyPress.

Ron

 

[Niklas Östergren]

Thank´s a lot Ronald!

I havn´t, yet, figure out how to use it but I´ll read about it and it seams,
by the name, that it might be something form me!

// Niklas

 

[Niklas Östergren]

Hmm!

I have read about these events (OnKeyUp, OnKeyDown, and OnKeyPress) but I
cant realy figure out how to use them to open up a form by pressing button
<Enter>.

Any help would be apreciated!

// Niklas