Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    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
    Nevada, USA
    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.

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

    Linq ;0)>
    Hope this helps!

    The problem with making anything 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