Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012

    Unanswered: clear unbound form fields on unbound multiple field search form

    I have an unbound search form with multiple unbound fields. I want to add a clear button so if the search doesn't return the results they want, they can hit clear and start over. What is the best way to do this? The results show up in a subform within the search form.

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 18
    Clearing the fields in the unbound form is easy - just list them, and set all their values to null/""/0/whatever empty values you want.
    Given that you haven't explained how the search terms are used, it's difficult to work out how to clear any results set from a sub form.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Tags for this Thread

Posting Permissions

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