Results 1 to 3 of 3

Thread: Select All (97)

  1. #1
    Lounger
    Join Date
    Nov 2003
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Select All (97)

    Can anybody tell me how I can get a query to return all records, when I'm using a combo box with a drop down list?

    Thanks.

    Blitzy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Select All (97)

    You don't explain where the combo box comes from. If you mean that you have a form with a combo box, and set the criteria for a field in the query to [Forms]![FormName]![ComboBoxName], you can set the criteria to the following instead:

    Like IIf(IsNull([Forms]![FormName]![ComboBoxName]),"*",[Forms]![FormName]![ComboBoxName])

    Of course, you must replace FormName and ComboBoxName with the actual names. Another way is to leave the existing criteria as they are now, but to add a column [Forms]![FormName]![ComboBoxName], clear the Show: check box for this column, and set Is Null as criteria on an otherwise empty criteria line (i.e. not on the line containing [Forms]![FormName]![ComboBoxName] as criteria.)

    If you meant something different, please explain.

  3. #3
    Lounger
    Join Date
    Nov 2003
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Select All (97)

    Hi hans, one of my colleagues has pointed me in the direction of the Access Developer Solutions Database, and I'm finding it helpful.... Think I can probably get what I want from this. Thank you very much for your help in any case.

    Regards. Blitz

Posting Permissions

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