Search box of the Record Selector

  • Thread starter Thread starter Jac Tremblay
  • Start date Start date
J

Jac Tremblay

Hi,
Is it possible to set the focus on the Search box of the Record Selector
when a form is displayed (when some value has been set before)?

That way, when the user types something, he will not modify the existing
record. He will in search mode by default.

Thanks.
 
Hi,

"Tremblay" such as a town in France !!!

Here a solution :
Private Sub cmdSearch_Click()
SendKeys "^+{F}", True
End Sub

--
Argy
Goto : http://argyronet.developpez.com/
Livres :
Créez des programmes avec Microsoft Access 2007 (ISBN 2742982442)
VBA pour Office 2007 (ISBN 2742983910)
 
Hi again Argy,
I tried that again and it does work (it did not in debug mode).
I found out that it is the keyboard shortcut for Find, Ctrl + Shift + F.
But what is the parameter True for?
Thanks again, that is a cute solution.
 
Back
Top