Results 1 to 2 of 2
  1. #1
    siddel77 is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    8

    Problem in Search Form

    Hi everyone,
    I found some strange behaviour in a simple search form.
    I have 5 checkboxes (step1, step2, step3, step4 and step5) and a button that calls an access query. This query takes values from the checkboxes to filter the results.


    It is compulsory for being in some step (e.g. step3) to pass through all previous steps (step1, step2).
    I build the query so that I need to check step1, step2, step3 if i want all the rows that have step3 = true. But this is not the problem.
    The problem is that the only way I found to make the form behave correctly is to check, and uncheck all checkboxes before I check the ones I want to search for.
    How can I correct that?

    Thanks in advance

    PS: Sorry if my english is not correct. Im not a native speaker.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    We need something to analyse. Show code or attach project.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Search Form
    By roger556 in forum Forms
    Replies: 5
    Last Post: 07-16-2011, 02:11 PM
  2. Replies: 9
    Last Post: 02-15-2011, 03:05 PM
  3. Search box on a form.
    By annaisakiwi in forum Forms
    Replies: 3
    Last Post: 01-02-2011, 08:39 PM
  4. Search problem with form
    By JackT in forum Forms
    Replies: 2
    Last Post: 09-01-2010, 12:03 PM
  5. Replies: 2
    Last Post: 06-14-2010, 03:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums