Custom menu question

[wabtrainer]

How can I utilise th F1 key from a custom menu?
I have tried to use SendKeys but get an error.
I am using Access 2000.
Cheers


If you want to be a bear:
Be a Grizzly!

 

[missinglinq]

I'm not exactly sure what you mean by "How can I utilise the F1 key from a custom menu?" but you can assign special functions to most any key by the following VBA code:

'This tells Access to check keys when first pressed
Private Sub Form_Load()
Me.KeyPreview = True
End Sub

'This assigns various keys special functions
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode

Case vbKeyEscape
'Your code here for when Escape is hit

Case vbKeyF1
' Your code here for when F1 key is hit

Case vbKeyF2
' Your code here for when F2 key is hit

Case vbKeyF3
' Your code here for when F3 key is hit

Case Else
End Select
End Sub

While you can assign the F1 key in this manner, you should remember that in doing so, you are doing away with the user's ability to use Access' own help system by pressing the F1 key. This should be kept in mind when reassinging any key that already has a built-in function.

Hope this helps.

The Missinglinq

There's ALWAYS more than one way to skin a cat!