Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Clear Spring, Maryland, USA
    Thanked 0 Times in 0 Posts

    Find Record (XP)

    I am trying to add a button on a form that would allow me to search for a specific last name (which is an indexed field) and then jump to that record. I'm not even sure what keywords to search for if a thread has already answered this. Any help?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Find Record (XP)

    One possibility is to have a text box in which the user enters (part of) a name, and a command button that selects the first record that matches. See <post#=198933>post 198933</post#> for an example.

    It is also possible to use a combo box to search for records. Activate Control Wizards (the "magic wand" button on the Control Toolset must be "on") and place a combo box on your form. In the Combo Box Wizard, select the option to look up records based on the selection in the combo box. The wizard will write the necessary code for you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts