"Look In" combo in the Search Box

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • puzzled
    New Member
    • Sep 2008
    • 1

    "Look In" combo in the Search Box

    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?
  • DonRayner
    Recognized Expert Contributor
    • Sep 2008
    • 489

    #2
    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.

    Comment

    • ADezii
      Recognized Expert Expert
      • Apr 2006
      • 8834

      #3
      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

      Comment

      Working...