Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    11

    Unanswered: requery a list box while typing in a text box

    I've seen search form that look like they only have one text box and one list box.

    When the user starts typing characters in the text box the list box is requeried to display only records with the typed character in the first colum and then the text box tries to complete the typing ( just like in a combo box). This proccess is repeated for every typed character in the text box. Does anyone know a way I can do this?

    I can think I would be able to do it with a combobox but I don't know how to remove the drop-down arrow on comboboxes.

  2. #2
    Join Date
    Jul 2004
    Location
    Blackburn, UK
    Posts
    169
    Dont know if this is going to be correct but you could try something along the lines of

    On the Key Press on the Text Box

    Code:
    Dim SQL as string
    SQL = "Select [TblName].FldName"
    SQL = SQL + " From [TblName]"
    SQL = SQL + " Where (([TblName].FldName) = (Forms!FrmName!TxtBox))
    Forms!FrmName!ListBox.Recordsource = SQL
    Refresh
    Dont actually know if that will work but it will be something like that

Posting Permissions

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