open a small popup form by pressing functional key.....

[alex_raju]

hi,


i have a ms access 2003 form with txtProductID, txtdescription, txtprice, txtqty. now,if i want search a productid i want open a small popup searching form by pressing functional key.....[f6,f7,f8..like] when cursor on txtproductID.

thankyou

alex

[ssanfu]

The Function Keys
In Microsoft Windows, key functions vary from application to application. There is, however, some common functionality between programs. Common function key tasks include:

F1: The F1 key is almost universally used to access help files. By pressing WINDOWS KEY + F1, you can access the Windows help and support center.
F2: The F2 key is used to rename the selected file or object.
F3: The F3 key is often used to access the search function of an application. On the desktop, F3 will call up the detailed Search Results window.
F4: Typing ALT + F4 will close the currently active program.
F5: This key will refresh the contents of a dialog box (e.g., Save As). In most browsers, F5 will refresh the currently displayed Web page.
F7: Sometimes used to call the Spell Check function of an application. Microsoft Word and Open Office both support this command.
F10: The F10 key makes a program’s Menu Bar active. SHIFT + F10 will display an item’s shortcut menu-the equivalent of right clicking on an item.
F11: This key is used in most browser programs to switch into full-screen mode

Windows doesn’t use all of the function keys. You can take advantage of this by assigning a program to an “empty” function key. F8, F9 and F12 are good candidates.

To have F12 open a form, set the property "Key Preview" to YES.
Then add this code:

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
   If KeyCode = vbKeyF12 Then
      KeyCode = 0
      DoCmd.OpenForm "Form2"
   End If
End Sub

Of course, change "Form2" to your form name.

[alex_raju]

fantastic...

and very perfect answer with more information

thank a lot