Search box of the Record Selector

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.
 
A

Argyronet

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)
 
J

Jac Tremblay

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top