Hello All,

Here is the solution to a problem I had earlier involving function keys.

Problem: How do you make a function key call a sub, like Private Sub cmdSearch_Click(), while another control has focus.

Solution: You have to set the forms keypreview property to true. You can do this at design time or during runtime with code ex - frmMain.KeyPreview = True

From there it is a simple issue of the select case statement. Here is the reference from the MSD-Library.

KeyPreview Property Example
This example creates a form keyboard handler in the KeyDown event. Each of the first four function keys displays a different message. To try this example, paste the code into the Declarations section of a form, and then press F5. Once the program is running, press any one of the first four (F1 – F4) function keys.

Private Sub Form_Load ()
KeyPreview = True
End Sub

Private Sub Form_KeyDown (KeyCode As Integer, Shift As Integer)
Select Case KeyCode
Case vbKeyF1: MsgBox "F1 is your friend."
Case vbKeyF2: MsgBox "F2 could copy text."
Case vbKeyF3: MsgBox "F3 could paste text."
Case vbKeyF4: MsgBox "F4 could format text."
End Select
End Sub


Sal

P.S. - Thanks to Megatron & Kedman for their leads to a resolution to this problem. This is a great forum.