The F8 key

Does anyone know how i could use the F8 key to act as a cmd button click_event??

Say i had a text box that searched a database. When i enter values into that textbox i want to be able to press F* to execute what is contained in the cmd button's click event! Any ideas??

I already know how to execute the click event by pressing enter, but was wondering if it could be done through F8??

Any ideas??

Many thx in advance

VB Code:

Private Sub Text1_KeyUp(KeyCode As Integer, Shift As Integer)
    If KeyCode = vbKeyF8 Then
        MsgBox "do u'r stuff"
    End If
End Sub

What if, depending on the f8 key being pressed i wanted to execute the entire contents of the cmd button.....and there is quite a few calls to modules in it?? How could i do this?

many thx in advance

VB Code:

Private Sub Text1_KeyUp(KeyCode As Integer, Shift As Integer)
    If KeyCode = vbKeyF8 Then
        Call Command1_Click
    End If
End Sub

Many thx Peet, sorry for the stupidity!!

don't be sorry :D

I know the answer because I once wondered myself :)