find command defaults

G

Guest

I have the find command on a button in a form. I would like to change the
defaults for the find command to the field that is active (where the cursor
is) at the time the find window is opened (control f key). (ie rather than
whole form, search just that field value). How can I do this?
 
A

Allen Browne

When you click the button, *it* is the active control.
Since the button is not bound to a field, the Find defaults to all fields.

SetFocus to Screen.PreviousControl if you want to Find on the field.
 

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

Similar Threads

'find' command button 1
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Command Button "Find" 9
Command Button to Use Toolbar Find 1
First field default in form with header & details 3
finding a record in continuous forms 4
Creating Command Buttons On The Fly 1
Open specific form from cmd button 3

Top