Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    2

    Talking Unanswered: Help With Search

    I have created a database for our department. When someone places a work request the tech opens the form and the form lets him know that a new request has been made. What I want then is for him to press a search button and have it automatically search my received field. If the received is not checked then it should display it on the same form.

    Any one can help?

    Thanks!
    Last edited by flpanther27; 01-23-05 at 21:59.

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    In the OnCurrent event of your form, enter this code:

    Me.Filter = Null
    Me.FilterOn = False
    __________________________________

    In the OnClick event for your search button, enter code something like this:

    Me.Filter = "[Revieved] = True"
    Me.FilterOn = True
    Me.Requery
    __________________________________



  3. #3
    Join Date
    Nov 2002
    Posts
    2

    Talking Got it!

    Thanks! that worked great!

Posting Permissions

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