Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Harrow, UK
    Posts
    53

    Unanswered: How do I hypersearch on a form?

    I have a table with two fields, CODE and DESCRIPTION.

    I have a form with a Textbox and below it a two-column Listbox.

    By default the Listbox displays all the records.

    I want the user to start typing in the Textbox, and for the Listbox to start showing only those records which contain what is typed. I believe this is called a hypersearch.

    Any ideas?
    Thank you,
    James

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465

    Talking How do I hypersearch on a form?

    James

    Te contesto en spanish no manejo bien el ingles.

    1) La consulta que da origen a tu cuadro de lista tiene que tener un criterio de seleccion basado en el cuadro de texto.
    Y este control cuadro de lista debe estar no activado
    2) Un vez que el usuario ingreso un dato en el cuadro de texto y dio la salida, habilitar el cuadro de lista y ejecutar un requery de este control
    para mostrar los registros que cumplan con el criterio de seleccion
    basado en el cuadro de texto.


    Espero te sirva.

    Saludos Norberto




    salida
    Saludos
    Norberto

  3. #3
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465

    Talking How do I hypersearch on a form?

    James

    I send to you a Sample.mdb in a zip file format.
    I thing that cant be a solution of your problem.

    Saludos Norberto
    Attached Files Attached Files
    Saludos
    Norberto

Posting Permissions

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