Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    61

    Unanswered: where clause from combobox

    I have a combobox in which i can pick a number of values. I also have a query which gets it's where clause from this combobox. The problem is that I also want to be able to pick no value at all in the combobox and that the where clause of the query remains empty and just selects everythig . I have tried to do this by putting this:

    IIf(is null([Forms]![frm_reconciliation]![Combo1])=true; Like "*";[Forms]![frm_reconciliation]![Combo1])

    in the where clause of the query but it does not work. If I don't pick a value the query will return nothing.

    Any suggestions??
    Nobody dies a virgin because life screws us all!

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6

Posting Permissions

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