Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5

    Unanswered: On change event and requery form

    I have a form (continuous form) and at the top of the form is a textbox that after I type any number of characters - I click a search button and then the code builds a sql statement using the contents of the textbox as "like" statements across multiple columns to
    return any matching records by resetting the recordsource to the sql statement and requerying

    It works fine but I have to click the search button to see the results

    How can I use the change event to build and run the query as I type the characters - like a "real-time" search as I type?
    Dale Houston, TX

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    The trick to using the change event is using the .Text property of the textbox rather than the default .Value. I'd probably use the after update event and let the user hit enter when done entering.
    Paul

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    If the search string is ten characters long...do you really want to build and run ten Queries? Seems a little resource-intensive, but Allen Browne has a utility for doing just that:

    http://allenbrowne.com/AppFindAsUType.html

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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