By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,678 Members | 1,467 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,678 IT Pros & Developers. It's quick & easy.

"Look In" combo in the Search Box

P: 1
I have "Find" buttons throughout my database, each with focus on a different field (they were created with the wizard, then the focus set to the corresponding field with VB). If i press a find button and change the "Look In" combo to search the form instead of a field, the next "find" button i press defaults to 'Look In' the form, not the field that should have focus. The field that should have focus is available to select in the "Look In" combo box but it always defaults to the form name instead. I don't want the user to have to select from the "Look In" combo, i want it to default to the corresponding field name

Is there a way to make the "Look In" combo in the "find" box always default to the field that has focus instead of the full form?
Sep 22 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 489
Not sure if it's the correct way or not but I usually just add a "me.mytextfield.setfocus" into the on click event for the search button. The reason that it's defaulting to the entire form is that the button has focus when you click it.
Sep 22 '08 #2

Expert 5K+
P: 8,692
Assuming you have the Focus isue handled prior to the Find:
  1. Tools
  2. Options
  3. Edit/Find Tab
  4. Select the 'Fast Search' Option
  5. OK
  6. Close the Database
  7. Re-open the Database
  8. You should now be able to perform Searches defaulting to the specific Field(s) having the Focus instead of the Form
Sep 23 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.