Create hot keys to insert data 1

[jmstarbuck]

I'm not sure I'm using the right terminology with "hot keys" here. I've tried some general searching and I'm not finding anything helpful, so please bear with me.

I have a table containing text that I want to paste into fields when a user presses an associated combination of keys.

KeyCode as integer, KeyText as text

My plan has been to use dlookup to retrieve the text value once I have captured the keystrokes.

I've tried to implement this by using the form's keydown event, but I can't figure out how to use a combination of keys there. As soon as I press Ctrl, the event fires. I want to be able to use user defined Ctrl+ key combinations.

Is there a standard way to do this? I'm sure it is not an original idea. I'm open to alternate suggestions.

Any help would be greatly appreciated.

J

 

[PHV]

Test the second parameter of the KeyDown procedure.
This is clearly explained in the VBA help for the KeyDown event procedure.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886