Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Dec 2003
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Where condition written on report (Access 2000)

    Where Condition written on the report
    How can i write the where condition on a text box in a report?

    I am opening the report with the help of a combo box and the
    following where condition:

    View:=acPreview, WhereCondition:="OrderID > " & Me![CboOrders]

    Can i add on a control on the report saying that this is a list
    of all orders greater than the order selected in the combo box?

    What i have tried is :

    ="List of all the orders greater then : " & "" & Forms!MyForm![CboOrders![orderid]

    But i am afraid it doesnt make sense

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

    Re: Where condition written on report (Access 2000)

    I don't know why you tacked OrderID at the end of the expression, and there is an unmatched left bracket [. Does the following work?

    ="List of all the orders greater then : " & Forms!MyForm!CboOrders

  3. #3
    Lounger
    Join Date
    Dec 2003
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where condition written on report (Access 2000)

    Thnk you !! Of course you are right !!

Posting Permissions

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