Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012
    Posts
    132

    Unanswered: How to bypass a criteria by no selection?

    The criteria of a query is coming from a dropbox on a form. There are 4 selections in the dropbox. I want the query bypass the criteria and show all the records if the user does not select anything. However, the criteria will still work if the user selects an item from the dropbox.
    Thank you
    ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
    I asked god to please give me everything to enjoy the life, God said: i gave you the life to enjoy everything.

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Look at "DemoAllRecordsA2000.mdb" (attachment, zip).
    Look at Form1 (Default value in "Combo0" properties, and Limit to list properties), look at "Query1". Open form and try.
    Chose in Combo0 or put "*".
    Attached Files Attached Files

  3. #3
    Join Date
    May 2012
    Posts
    132
    thank you very much
    ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
    I asked god to please give me everything to enjoy the life, God said: i gave you the life to enjoy everything.

Posting Permissions

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