Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    Melbourne
    Posts
    92

    Unanswered: Search function troubles

    I have created my own search function using a sample that I found. The problem that Im having is that the Visa criteria doenst appear to work when the form is open and Visa option is used on its own. If it is selected and now matter which value is selected, the subform shows all the records. However, if a another criteria is selected in conjuction it appears to work Ok. The weirdest thing is after having using another criteria with the Visa Criteria, the Visa criteria own its own appears to work fine. I can allow this to happens becuase my user would get confused. User should be allowed to search on any one of the criterias provide on the form.


    I have tried everything to get the Visa Criteria to work on its own when the form is first opened but I can figured it out.

    I attached a copy of what I have done.
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2002
    Location
    Melbourne
    Posts
    92
    Never mine, I figured out my problem! I didnt set the record source of the subform to the query.

    It is amazing how something so simple can drive a person crazy .

Posting Permissions

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